venkat971

6 ms·

1.
by venkat971 8d ago
this can't come from FKs, in reality, FKs is bit outdated concept. The relationship among the objects always comes from the joins (from query logs). So by just looking at the schema, in a static sense, would not give us data flow pictu
2.
Ask HN: Best Platforms to Orchestrate Agents
3 points by venkat971 9d ago|2 comments
3.
by venkat971 9d ago
In the long run, I’m seeing it part of the database itself.
4.
High time for relational databases to start thinking?(deepsql.ai)
5 points by venkat971 10d ago|4 comments
5.
by venkat971 16d ago
Is this something one can self host? data does not leave the premises narrative is holding very strong in enterprises. We recently rolled out deepsql.ai - AI DBA as SaaS and quickly realized that anything that connects or touches the enterp
6.
by venkat971 26d ago
Data confidentiality and sovereignty matter a lot to enterprises. You may want to redact access to the most sensitive data from both humans and agents, and it gets tricky to enforce such dynamic policies at the database level. DeepSQL solve
7.
Giving an LLM your prod database is easy. Taking access away is the hard part(deepsql.ai)
4 points by venkat971 26d ago|6 comments
8.
by venkat971 26d ago
https://deepsql.ai/blog/giving-an-llm-your-database-is-easy-...
9.
by venkat971 2mo ago
Oracle has something like this, and I worked on this project when I was there. Although I was fascinated by the use cases, the adoption was pretty low in the relational world. https://www.oracle.com/in/database/int
10.
by venkat971 2mo ago
Yes, we never hired one. When we got the time to hire one, we developed this tool.
11.
by venkat971 2mo ago
We are making it open source by month end.
12.
by venkat971 2mo ago
Thank you!
13.
by venkat971 2mo ago
What is the stack that is required to setup your opensource repo? and what's the machine config you recommend. btw, I liked the pricing page. I am planning to setup a similar pricing page my project deepsql.ai (dba agent for postgres a
14.
by venkat971 2mo ago
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 wor
15.
by venkat971 2mo ago
Good luck with your project. happy to exchange notes, feel free to ping me at venkat@deepsql.ai
16.
by venkat971 2mo ago
Thanks :) Pl give it a try.
17.
by venkat971 2mo ago
Interesting topic, We built and use DeepSQL ( https://deepsql.ai/ ) at Stayflexi(YC) to address some of these issues. It's an DBA agent to prevent schema bloat, over indexing and does continuous monitoring of query workl
18.
by venkat971 2mo ago
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 abou
19.
by venkat971 2mo ago
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. Her
20.
by venkat971 2mo ago
We have cross checked with industry standard tools like pganalyze. Most them analyze the workloads in isolation. There are no continuous evaluations and context carry forward across the runs. DeepSQL does continuous evaluation of queries, w
21.
by venkat971 2mo ago
removed that metric. Our goal was to tell a convincing story with case studies. However, you are right on many dimensions that this number means nothing for many optimized scenarios.
22.
by venkat971 2mo ago
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 som
23.
by venkat971 2mo ago
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
24.
by venkat971 2mo ago
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 protectio
25.
by venkat971 2mo ago
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.
26.
by venkat971 2mo ago
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 DB
27.
by venkat971 2mo ago
Yes, it has built in storage layer(Postgres and PGVector)
28.
by venkat971 2mo ago
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 deploym
29.
Show HN: DeepSQL – A self-hostable DBA agent for Postgres and MySQL(deepsql.ai)
52 points by venkat971 2mo ago|35 comments
30.
by venkat971 3mo ago
Hints are great way to experiment, but should not live in live production queries. From my Oracle database days, we saw many customer workloads where old hints overrode the latest database optimizations. Believe in the optimizer's own

More ›