sqlbot
Talk to your databases in natural language. An AI-powered SQL assistant directly in your terminal and browser.
Ask anything about your database
Try typing a natural language query below
Everything you need
Supercharge your database workflow with AI.
Natural Language to SQL
Just ask your database questions in plain English. No need to remember complex SQL syntax.
Smart Charting & Stats
Automatically generates beautiful charts, metrics, and visualizations right from your data query results.
100% Local & Private
Bring your own API keys and connections. All your chats, connection strings, and keys are saved strictly on your local machine.
Free Local Embeddings
The embedding model runs entirely locally on your machine. Zero cost and maximum privacy for vectorizing your schema and knowledge base.
Supported Databases & Connectors
Connect locally and securely to your favorite engines.
PostgreSQL
Advanced open source relational database
MySQL
The world's most popular open source database
SQLite
C-language library that implements a SQL database engine
Amazon Redshift
Fast, fully managed, petabyte-scale data warehouse
CSV Import
Upload and query local CSV files instantly
More coming soon
We're adding support for more databases regularly
AI Providers
Bring your own API keys for your preferred AI models.
Google AI
Use powerful Gemini models
Groq
Ultra-fast inference
OpenAI
Industry standard models
Anthropic
Advanced Claude models
Coming Soon: oboe.chat Integration
Connect with your oboe.chat account to instantly use all supported models without managing your own API keys.
Documentation
Learn how to install, use, and configure sqlbot.
Installation
Install sqlbot globally via npm:
Usage
To start sqlbot, simply run:
This will start the local server and automatically open the application in your browser at http://localhost:1121.
CLI Options
| Option | Description |
|---|---|
| -p, --port <port> | Port to listen on (default: 1121) |
| -H, --hostname <host> | Hostname to bind to (default: 0.0.0.0) |
| --no-open | Don't open browser automatically |
| -v, --version | Show version |
| -h, --help | Show help message |
Example:
Configuration
1. AI Provider Setup
To use AI for SQL generation and chat, you need to configure an AI provider:
- Open sqlbot in your browser.
- Navigate to AI Providers (or visit
/ai-providers). - Click Add Provider.
- Choose between Google AI (Gemini), Groq, or OpenAI.
- Enter your API key and save.
- Google AI: Get keys from Google AI Studio.
- Groq: Get keys from Groq Console.
- OpenAI: Get keys from OpenAI Dashboard.
NOTE
Your API keys are stored securely in ~/.sqlbot/ai-providers.json.
2. Database Connections
Connect your databases to start querying in natural language:
- Navigate to Connections (or visit
/connections). - Click Add Connection.
- Select your database type (PostgreSQL, MySQL, SQLite, etc.) and enter the connection details.
- Once connected, sqlbot will index your schema to provide accurate SQL generation.