Your 24/7 DBA and Data Engineer

The database agent for Postgres and MySQL

Answers BI questions, fixes slow queries, and watches your schema 24/7.

Free to get started · Self-host in 15 minutes

Works with
ClaudeCodexCursor
venkat@laptop — deepsql — 120×34

██████╗ ███████╗███████╗██████╗ ███████╗ ██████╗ ██╗
██╔══██╗██╔════╝██╔════╝██╔══██╗██╔════╝██╔═══██╗██║
██║  ██║█████╗  █████╗  ██████╔╝███████╗██║   ██║██║
██║  ██║██╔══╝  ██╔══╝  ██╔═══╝ ╚════██║██║▄▄ ██║██║
██████╔╝███████╗███████╗██║     ███████║╚██████╔╝███████╗
╚═════╝ ╚══════╝╚══════╝╚═╝     ╚══════╝ ╚══▀▀═╝ ╚══════╝
I am your DBA and Data agent. DeepSQL is the brain for your database.
Try these prompts
Connections (4)
analytics-replica mysql
prod-warehouse postgres
deepsql-vault postgres
prod-primary mysql
Needs attention
⚠ analytics-replica · brain still initializing (73%)
→ deepsql connections init analytics-replica
⚠ prod-primary · brain still initializing (73%)
→ deepsql connections init prod-primary
42 brain recommendations to review → deepsql brain recs
Ask a question · exit to quit · deepsql --help for CLI commands
v0.26.0 · latest
[deepsql] >
Product

Your full-time DBA and Data Engineer, in one agent.

BI answers, slow query fixes, and schema watch — from one shared brain.

Agent

Ask the agent about database health or BI

DeepSQL Agent loads your business context, resolves schema, drafts and validates SQL, then executes on a read replica — with every step you can inspect.

what are the top 5 customers having large velocity of data in last 7 days?
7 steps · brain · schema · workload · executed
  1. Loaded brain contextcustomers · sales_report_aggregation · velocity metric
  2. Resolved schemapublic.sales_report_aggregation · public.accounts
  3. Checked workload patternssimilar aggregation seen 42× in last 24h
  4. Drafted queryGROUP BY account_id · SUM(rows_ingested)
  5. Validated planindex scan on idx_sra_created_at · 38ms est.
  6. Confidence: highmatches 3 governed metrics in brain
  7. Executed on read replicareturned 5 rows in 41ms

Top 5 customers by rows ingested into sales_report_aggregation over the last 7 days:

CustomerRows / dayΔ vs prior wk
Aurora Hospitality (30469)4.82M+18%
Nordic Stays Group (28104)3.91M+12%
Coastline Resorts (31287)3.44M+9%
Meridian Hotels (29553)2.87M+6%
Lumen Suites (30988)2.31M+21%

Combined 17.35M rows/day — 62% of total ingestion volume.

BI

Dashboards without the analyst backlog

Ship BI directly from the warehouse. Pre-aggregated, governed by your brain, and always in sync with production schema.

Dashboard
Rooms sold & revenue
Rooms sold
585
Revenue
$15.6K
ADR
$26.87
Rooms sold by day
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Brain

The business context your database is missing

Teach DeepSQL your metrics, rules, and conventions once. Every query, dashboard, and recommendation uses the same governed definitions.

Brain
Teach DeepSQL how your business works
5 of 41
Slow Queries

Find and fix the queries costing you money

Per-fingerprint trends, regressions, and by-customer breakdowns — sourced from pg_stat_statements or the MySQL slow log.

Slow queries
Per-query analytics · last 30 days
Tracked queries (6)
6 queries regressed on the latest runAggregation query is 13.33× slower vs baseline.
Aggregation query
query hash · 6821d4140d0e5365
SELECT hotel_id, SUM(net_room_revenue) rev,
COUNT(*) rooms_sold
FROM sales_report_aggregation
WHERE report_date >= CURRENT_DATE - INTERVAL '90 day'
GROUP BY hotel_id;
Mean execution time / day
last 14 days · peak 5.3
Jul 5Jul 10Jul 14Jul 18
How it works

From zero to a working database agent in 15 minutes

Self-hosted end-to-end. Your data, your credentials, your VPC.

1
Install
One line

Run a single command on any Linux box, EC2, or container in your VPC. Installs the DeepSQL agent, CLI, and MCP server on the machine.

2
Setup
Point it at your data

Add database connections, teach it your company's knowledge, and feed it your slow query logs. DeepSQL indexes your schema and starts learning your workload immediately.

Database connections

Postgres or MySQL — read replica, VPC-peered. Read-only credentials, no data leaves your infra.

host: aws-rds-replica.internal
role: deepsql_ro
ssl: require
Company knowledge

Teach DeepSQL your business rules in plain English — MRR, active-hotel, currency conventions.

// MRR = SUM(subscription.mrr)
// WHERE status = 'active'
// Active hotel = check-ins ≥ 1 / 30d
Slow query logs

Point at pg_stat_statements or MySQL slow log. DeepSQL clusters, ranks, and starts recommending.

source: pg_stat_statements
window: 30d rolling
grouped: 1,284 → 96 fingerprints
3
Go live
Start chatting

Chat with the built-in DeepSQL agent in your browser, or connect Claude, Codex, and Cursor to your DeepSQL instance over MCP or CLI.

Works with
ClaudeCodexCursor

Put your database on autopilot.

One-line install. Self-host in 15 minutes. Role-based access, query policies, and audit logs built in.

Read the docs
The DeepSQL Blog

Field notes from inside the database

Deep dives on cutting Aurora costs, replacing Tableau, and why your observability bill is a lie. Written for senior DBAs and data engineers.

Read the blog