I am super excited to introduce you to SQLPilot!
You may have worked with SQL, and it's essential for developers. I used to use ChatGPT to generate queries for me, and I discovered that many of my colleagues with less technical backgrounds also use ChatGPT for this purpose. While ChatGPT is really helpful, it comes with some problems: - ChatGPT doesn't know your schema and relationships to build accurate queries. - You need to copy and paste your schema to craft better queries. - There are online tools that help build queries but require you to provide credentials to connect to the database or provide the schema, which is a big privacy concern.
This was something that bothered me and many others. To solve this, I decided to build a SQL editor with AI query generation.
With SQLPilot, you can: - Connect to multiple database sources like MySQL and Postgres (support for others coming soon). - Works locally, so you don't have to share your schema as you do with other popular tools. - Simply mention the table in the prompt with @, and the model will understand its columns, types, and relationships to generate accurate queries. - Execute the queries, filter results, and export them as CSV.
I warmly invite you to try out SQLPilot (https://sqlpilot.ai). Whether you're a beginner or advanced in SQL, it will definitely interest you! Use code HN25OFF to get 25% off on the Pro plan!
Show HN: SQLPilot – AI First SQL Editor
sqlpilot.ai