SQLPilot

Hello Product Hunters 👋 I am super excited to introduce you to SQLPilot! You may have worked with SQL, and it's something must for developers. I used to rely on ChatGPT to generate queries for me and discovered that many of my colleagues with less technical backgrounds also use ChatGPT for query generation and analysis. While ChatGPT is incredibly helpful, it comes with its own set of problems! Problems 😶: ChatGPT doesn't know your schema and relationships, which affects query accuracy. 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 supply the schema, which raises significant privacy concerns. This was a major pain point for 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 other databases coming soon). Work locally, so you don't have to share your schema like you do with other popular tools. Simply mention the table in the prompt with @, and the model will recognize its columns, types, and relationships to generate accurate queries. Execute the queries, filter out results, and export them as CSV. I warmly invite you to try out SQLPilot. Whether you are a beginner or advanced in SQL, it has something for everyone! Use code PRODUCTHUNT25 to get 25% off on the Pro plan!

This sounds incredibly useful for both beginners and advanced users of SQL. Any plans to support more database types in the near future? Congrats on the launch!

Hi, does it work if my table is a csv instead of a database? Would love to learn more. We are looking for something like this for our product but we are not a data storage provider

Congrats on launching SQLPilot! The ability to write SQL queries in natural language is a game-changer. Looking forward to seeing how it streamlines database management!

I just tested the windows app it doesn't work. I have MySQL 5.7 database in my localhost and SQL pilot app is connected to it but the database tables are empty.

The pricing is ridiculous. The app concept it's nice and useful, but you can copy the schema and do the same with a local database or asking any only model, without the auto competition, that's why it's just crazy to pay a that monthly fee, that's money grabbing, I'm out, it's the first time I would downvote an app, even liking it.