Data Connections (Natural Language SQL)

​

Supported Databases

​

Supported Vector Stores

Vector store connections are used by the Vector Retriever data source type and Flow Designer vector store tool nodes. See Vector Store Integration for details.

​

Advanced Features

// First question establishes context
await executeNaturalLanguageQuery({
  question: "What are our top 10 customers by revenue?",
  connectionId: "...",
  userId: "...",
  sessionId: "session-123"  // Creates context
});

// Follow-up question uses context
await executeNaturalLanguageQuery({
  question: "Which of those are in California?",  // References "top 10 customers"
  connectionId: "...",
  userId: "...",
  sessionId: "session-123"  // Uses same context
});

​

How It Works

1. Configure a connection — In Admin → Data Platform Connections ([#/admin/databases], setting key databaseConnections), create a connection with host, port, credentials, and schema/catalog
2. Attach to a chat — Select the connection on the chat configuration
3. Schema discovery — The system introspects the database schema (tables, columns, types, relationships)
4. Query generation — The AI receives the schema context and generates SQL from the user’s natural language question
5. Execution — The generated SQL is executed against the connection and results are formatted for display
6. Visualization — Results can be rendered as tables or Recharts visualizations (bar, line, pie, area charts)

​

Security

• Read-only by default — Connections are configured with read-only intent where possible
• Schema filtering — Admins select which schemas/tables are visible to the AI
• API key auth — Data Platform Tools use a separate API key (sqlToolsApiKey) for authentication
• Row limits — Query results are capped to prevent excessive data transfer

​

Database SDK Versions

​

Recharts Visualizations

• Bar charts — Categorical comparisons
• Line charts — Trends over time
• Pie charts — Proportional data
• Area charts — Filled line charts for volume data