Show HN: DeepSQL – A self-hostable DBA agent for Postgres and MySQL

hckrnws

Show HN: DeepSQL – A self-hostable DBA agent for Postgres and MySQL

by venkat971

Hi HN - I'm Venkat, founder of Stayflexi (YC), CMU CS grad and Ex-Oracle Query Engine team (patents in core databases)

DeepSQL started as an internal tool to stop our own databases from becoming the bottleneck they were becoming (13,000+ hotels in production). It worked well enough that we're releasing it.

DeepSQL is an AI agent that operates a database the way a senior DBA and Data Engineer would

1. Fixes slow queries (we cutdown DB spend by 4x) 2. Fixes DB bloat (blocks unnecessary schema changes, in vibecoded setup) 2. BI dashboards(we removed spend on tableau, retool and appsmith) 3. Security (We could redact access to sensitive, PII data to our employees) while engaging everyone in the org to interact with our database

How it works 1. Deepsql learns your data and relationships from your code base, rules and query logs 2. Deepsql agent has 20 background jobs that continuously monitor the schema changes, bottlenecks, and come up with solutions before the problem arises. (Schema bloat issues are irreversible) 3. Deepsql Brain has CLI and MCP surfaces that can directly work with Claude / Codex and Cursor. 4. Deepsql digest delivers the daily database health report. 5. Your team can connect to deepsql with their favourate surface areas - Web UI, CLI, MCP or Slack.

One line install: curl -fsSL https://install.deepsql.ai/install.sh | bash

For community support: https://discord.gg/duEJq7AeeG

Or just email me for expert level setup guidance venkat@deepsql.ai

docheinestages
22d
The landing page doesn't show a link to your GitHub. Despite mentioning "self-hostable", I genuinely thought it was closed-sourced. I doubt first-time users will trust a random tool and grant it database-level access with a curl command.
1. venkat971 • OP
  02d
  Great point and thanks for the feedback. We made it self-hostable so that data doesn't leave the premises. We haven't open sourced the code yet, but most likely we will head in that direction very soon.
2. pella
  02d
  now: https://github.com/DeepSQLAI/deepsql-self-host
Arshad-Talpur
12d
Though the core of the product seems to be younger enough and also i couldnt find a link to github for more detailed query but the direction about database should do more and it should evolve as per needs of Agentic Era seems to be fascinated and I am already working on that direction from my end too, Wish you best for this project.
1. venkat971 • OP
  01d
  Good luck with your project. happy to exchange notes, feel free to ping me at venkat@deepsql.ai
malamz
12d
Combining background query optimization with PII redaction in a self-hostable setup is such a solid combo for small engineering teams. Impressive release!
1. venkat971 • OP
  01d
  Thanks :) Pl give it a try.
venkat971 • OP
14d
Deepsql doesn't replace your DBA, it gives your DBA super powers. In my org, when we had to decide on hiring a DBA, we chose building deepsql and empowered our senior engineer to handle the database tasks like a senior DBA.
For deployment help, pl email me at venkat@deepsql.ai
1. sehw
  02d
  [dead]
vector_spaces
12d
> 2. BI dashboards(we removed spend on tableau, retool and appsmith)
Can you explain this in more detail? You saying that DeepSQL can create BI dashboards that makes Tableau and friends redundant -- are you talking about analytics dashboards consumed by business teams or more like db ops dashboards used by backend teams? Does the user prompt the agent for them, or does it build dashboards that it infers are needed?
1. venkat971 • OP
  02d
  Deepsql has built in BI dashboards server - You can ask agent to build any BI dashboard from the connected data sources (this can be used by your internal teams or you can even share the dashboard link with customers with password protection, just like how we would share the retool links).
mdasen
32d
Is this an open source tool? Is it something we have to pay for? The site really doesn't tell me what I should be expecting.
1. pella
  12d
  https://github.com/DeepSQLAI/deepsql-self-host
quard8
32d
inside install.sh file i found this:
printf " ${DIM}This install is using DeepSQL's shared managed Azure OpenAI key, so your${RESET}\n" printf " ${DIM}schema and queries are processed through DeepSQL's shared LLM resource.${RESET}\n"
also, it requires docker.
1. venkat971 • OP
  22d
  Hi, yes. Right now we are bundling our key to maintain the consistency of DeepSQL agent performance. We will lift this key bundling very soon, for enterprise deployment we might allow BYOK (bring your own key)
  Yes, this requires docker. Here is more technical documentation on prerequisites and suggested setup (including AWS CFT)
  https://docs.deepsql.ai/quickstart/
[deleted]
03d
[deleted]
pella
02d
https://github.com/DeepSQLAI/deepsql-self-host
bosky101
12d
It feels like ppl will churn after they fix their indexes / get their large savings once. All the best though.
1. venkat971 • OP
  01d
  optimizing the queries and schema monitoring just one aspect of Deepsql. It has built in BI server - security and policies enforcing module (on who can read what data) - All these can be wired in to the regular business and data lookup workflows.
shenli3514
32d
This is an interesting product. Any comparison with other DBA tools? There are many tools can fix the slow queries, based on rule+statistics.
1. venkat971 • OP
  22d
  Deepsql doesn't require any predefined rules + stats, nor you need a DBA to operate it. It's an autonomous agent, that learns your business context, schema, join relationships and creates a mental map of everything (just like a DBA who joined your team). This we call it deepsql brain init stage. Once the init is done, it will then look at all slow queries workload, comes up with comprehensive suggestions of indexes, MVs etc. Other DBA tools might look at one query at a time, if we try to optimize one query at a time, we might over index.
  Also, deepsql is intelligent in understanding the deployment type. Postgres standalone deployment is very different than Aurora postgres. Cost factors are quite different. Other DBA tools might ignore these factors - Hence they need well trained DBA to use them.
evanelias
32d
> cut database costs by 40%
Where does this number come from? It feels completely arbitrary.
1. venkat971 • OP
  22d
  We did cut our overall DB spend by more than 3x. Our $9K spend drops to $3k - indexes not kicking in, rapid growth of log tables and schema bloat were the culprits. Also, we removed the retool and appsmith licenses, another $2k savings.
  We worked with 6 YC companies who are running on Aurora postgres and worked through the inefficiencies of workloads - too many indexes (in some cases almost every column is indexed), over indexing significantly increases I/O ops (writes), this hidden costs are enormous for fully managed services like Aurora. In all these cases, we could safely come up with a plan to cut down their DB spend by more than 40%.
opwizardx
12d
How is it different from Claude Code with access to Oracle docs?
1. venkat971 • OP
  02d
  Claude would not do the frequent schema drift changes, data relationships, block the query execution due to PII leak, cardinality calculations of key columns… 20 other parameters that effectively works like a well trained DBA. It’s all about harnessing the agent. And our harness can work with Claude or other coding agents to perform efficient DBA tasks.
  Eg: our security harness blocks sensitive data from being queried, and this can be enforced at the user level. It takes effort to build and maintain such harnesses around claude at the org level.
that_dba_guy
13d
So, does it help with context management or so called MemoryBank setup?
1. venkat971 • OP
  03d
  Yes, it has built in storage layer(Postgres and PGVector)
varunsls
01d
[dead]