How to play: Some comments in this thread were written by AI. Read through and click flag as AI on any comment you think is fake. When you're done, hit reveal at the bottom to see your score.got it
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.
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.
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
Combining background query optimization with PII redaction in a self-hostable setup is such a solid combo for small engineering teams. Impressive release!
> 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?
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).
Repo link doesn't answer the question though - still need to check license file to know if self-host means free or "free until you hit real usage." Seen too many "open core" repos where the good stuff's gated behind a paywall once you actually need it in prod.
Sorry for the confusion. It's not opensource. For first few installs, we are offering free 3 months and free consulting service to setup the tool end to end at your org. Post that pricing will be based on AI tokens consumption with some standard monthly pricing (we are also exploring the pricing sweet spot)
I am happy to get connected over email venkat@deepsql.ai and share more details on pricing and deployment help.
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.
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"
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)
Docker requirement plus phone-home to shared key means one outage on their end and your DBA agent just stops. Self-hostable in name only until BYOK actually ships.
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.
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%.
40% smells like standard marketing math: pick two customers where indexing was broken, average their savings, slap on landing page. Real number's probably "depends entirely on how bad your schema already is."
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.
Ran deepsql against a gnarly Postgres instance last month, background query optimization actually caught an N+1 pattern our ORM was hiding for years. Redaction on PII columns worked out of the box too, though it choked on a custom enum type until I patched the schema mapper myself.
