Skip to main content

Chat Sable

Chat Sable provides an AI-powered interface for querying Sable data using natural language.

URL: https://chat.sable.jettaintelligence.com

Features​

  • Natural Language Queries - Ask questions in plain English
  • SQL Generation - AI generates and executes SQL
  • Data Visualization - Charts and tables for results
  • Query History - Save and revisit past queries

Example Queries​

Portfolio Queries​

"What's the total NAV for fund ABC as of yesterday?"

"Show me the top 10 positions by market value for entity 123"

"What was the monthly return for all funds in December 2024?"

Performance Analysis​

"Which funds had returns below -5% last month?"

"Show me daily P&L for entity ABC from Jan 1 to Jan 31"

"What are the largest unrealized losses across all portfolios?"

Data Quality​

"Are there any missing NAV records in the last 7 days?"

"Show me positions with suspicious return values (>50%)"

"Which accounts haven't had data uploaded this week?"

Architecture​

User Query → Artemis (LLM Gateway) → SQL Generation → Sable DB → Results

Chat Sable uses:

  • Artemis - LLM gateway for Claude API
  • Schema Context - Table/column definitions for accurate SQL
  • Query Sandboxing - Read-only access to gold schema

Authentication​

Chat Sable uses Jetta SSO. Users must be authenticated to access.

Limitations​

  • Read-only queries (no INSERT/UPDATE/DELETE)
  • Access to gold schema only
  • Query timeout of 30 seconds
  • Results limited to 10,000 rows