SQLPilot

AI First SQL Editor - write complex queries with AI

105 followers

AI First SQL Editor - write complex queries with AI

105 followers

Visit website

Code editors

•

AI Coding Agents

•

Prompt Engineering Tools

SQLPilot is an AI first SQL editor which helps you write SQL queries in natural language by connecting to the database source and directly mentioning the context in the prompt

Free Options

Launch tags:Analytics•Developer Tools•Database

Launch Team / Built With

ReplayAutonomous app testing for teams who ship at AI-speed

Promoted

SuperCmd

Maker

📌

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!

Report

2yr ago

@shobhit98 Big shoutout for your launch! Wishing you endless success and new opportunities. What’s your vision for the future of this project?

Report

2yr ago

SuperCmd

Maker

@kjosephabraham Yes @kjosephabraham we are planning multiple things 1. We are enhancing our model to eliminate the need for sending schemas to ChatGPT. This will improve the accuracy and relevance of the output. 2. Implementing a fully natural language interface that automatically recognizes and selects tables, so you don’t have to mention them explicitly. 3. Expanding support to include more database sources such as Redshift, MSSQL, SQLite, and ClickHouse (as recommended by Kyrylo). 4. Introducing data visualizations for query results. If you would like anything to be added, please feel free to share your ideas! will def work upon that

Report

2yr ago

Fleak

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

Report

2yr ago

SuperCmd

Maker

@yc_j Hi Yichen, currently it's database only but sure we can do this for csv, can you send me your requirements here contact@sqlpilot.ai i will work on it and come up with the solution

Report

2yr ago

Fleak

@shobhit98 already did!

Report

2yr ago

SuperCmd

Maker

@yc_j Hi, reverted back! please check

Report

2yr ago

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.

Report

2yr ago

SuperCmd

Maker

@don_gap Hi Don, i will check this and get back to you, please allow me some time.

Report

2yr ago

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.

Report

2yr ago

SuperCmd

Maker

@cesar_couto The pricing is not for the app but mostly for the amount of generations, based on average size per generation, gpt4 is expensive, it costs $0.03 per 1k tokens, and average token size of each request is about 500-1500 tokens if you include 2-5 tables in query. i might be wrong about pricing but i really appreciate your feedback, i will lower the base price 👍

Report

2yr ago

Telebugs

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!

Report

2yr ago

SuperCmd

Maker

@kyrylosilin Yes definitely Kyrylo, planning to add Redshift, MSSQL up next, if you have any specific database that you want to be added, let me know. will add that as well

Report

2yr ago

Telebugs

@shobhit98 SQLite and ClickHouse

Report

2yr ago

Just Scroll

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!

Report

2yr ago

SuperCmd

Maker

@kehui_guo Thanks Kehui for the feedback!!

Report

2yr ago

Reviews