SQLPilot
SQLPilot is an AI SQL editor that generates accurate, optimized SQL queries from natural language prompts with knowledgebase support.
Last verified:
What is SQLPilot?
SQLPilot is an AI-first SQL editor that generates accurate and optimized SQL queries using natural language prompts. Users can write prompts in plain English or manually mention tables to generate SQL queries with their choice of AI model. The tool connects directly to database sources and leverages advanced language models to create complex queries efficiently, eliminating the need for extensive SQL knowledge.
Key features include Bring Your Own Key (users can add their own OpenAI key), Knowledge Base/RAG Support for better query output by connecting database context to the LLM, unlimited database connections, privacy and security (no storage of schemas, queries, or credentials), CSV download for results, and multiple GPT model support including GPT-3.5, GPT-4, and GPT-4o. The tool currently supports PostgreSQL and MySQL databases with more databases coming soon.
SQLPilot is designed for developers who need rapid query development, database administrators managing operations, data analysts exploring and analyzing data, and newcomers to SQL who want to learn query writing by observing AI-generated queries. It simplifies complex query writing and streamlines SQL workflow for anyone working with databases.
The free plan allows users to experience AI-powered SQL queries with no credit card required. Users can input their own OpenAI key to start generating queries immediately. The tool prioritizes data privacy by not storing user credentials or database schemas.
SQLPilot pricing
Pricing model: Freemium
SQLPilot offers a Free plan at $0 with no credit card required. The Pro plan is available at $9/month (originally $12). The Free plan includes basic AI-powered SQL query generation with limited generations. The Pro plan includes 500 GPT-4 generations, 200 GPT-4o generations, 2000 GPT-3-turbo generations, and Priority Support. Users must bring their own OpenAI key for either plan. Pricing packages are subject to change.
SQLPilot pros
- Generates accurate and optimized SQL queries using AI
- Supports natural language prompts for intuitive query creation
- Bring Your Own Key - use your own OpenAI API key
- Knowledge base/RAG support for better query output
- Unlimited database connections allowed
- Does not store schemas, queries, or credentials for privacy
- Download results in CSV format
- Supports multiple GPT models (GPT-3.5, GPT-4, GPT-4o)
- Currently supports PostgreSQL and MySQL databases
- SQL autocomplete functionality speeds up writing
- No credit card required for free plan
- Works on both Mac and Windows
- Connects directly to database sources
- Manually mention tables in prompts for context
- Reduced complexity and time for creating SQL queries
SQLPilot cons
- Limited database support (only PostgreSQL and MySQL)
- Graph and chart visualizations still in development
- Free plan has limited AI generations
- Excel support for downloads not yet available
- No native OpenAI key included - must bring your own
- More databases promised but not yet available
- Limited to text-based result views
- Priority support only available on paid plan
Frequently asked questions about SQLPilot
What is SQLPilot?
SQLPilot is an AI-first SQL editor that facilitates generating SQL queries through natural language commands. It uses advanced AI models like GPT-3.5, GPT-4, and GPT-4o to translate your descriptions into precise and optimized SQL queries ready to execute.
Is SQLPilot free to use?
Yes, SQLPilot offers a free plan that allows users to experience basic SQL query generation without requiring a credit card. The free plan includes limited AI generations, and users can upgrade to the Pro plan for unlimited generations and additional features.
Can I use my own OpenAI key with SQLPilot?
Yes, SQLPilot allows users to integrate their own OpenAI key to generate SQL queries. This Bring Your Own Key feature means you control your API costs and don't need to rely on SQLPilot providing model access.
What databases does SQLPilot support?
Currently, SQLPilot supports PostgreSQL and MySQL databases. The team has announced that more databases will be added soon, but at this time only these two database types are fully supported.
Does SQLPilot store my queries or data?
No, SQLPilot does not store schemas, queries, or credentials. The tool is committed to user privacy and security, only using the data you provide to generate SQL queries without retaining it afterward.
Can I download query results from SQLPilot?
Yes, SQLPilot allows users to download query results in CSV format. Excel support is mentioned as coming soon, so currently CSV is the only available download format for results.
What AI models does SQLPilot support?
SQLPilot supports multiple GPT models including GPT-3.5, GPT-4, and GPT-4o. Users can choose which AI model to use for generating their SQL queries based on their needs and the capabilities of each model.
How do I create a knowledge base for my database in SQLPilot?
To create a knowledge base, you label your tables to indicate their purpose and optionally label columns as well. You can also include custom instructions in rules to clarify how certain results are derived. The more detailed your knowledge base, the more effective query generation will be.
Can I provide examples of previous queries to SQLPilot?
Yes, you can optionally provide examples of previously generated queries. SQLPilot will select relevant examples based on the user's prompt to enhance query generation accuracy and consistency with your database patterns.
What platforms can I run SQLPilot on?
SQLPilot is accessible on both Mac and Windows platforms. You can access the software through the web at sqlpilot.ai and use it on either operating system without platform-specific limitations.