SQLPilot: AI SQL Query Generator and Editor is an AI-assisted tool designed to write accurate, optimized SQL queries with natural language prompts or explicit table references. It supports PostgreSQL and MySQL (with more databases coming soon) and offers features for custom key usage, knowledge-base aware generation, multi-DB connections, and secure handling of credentials. The platform emphasizes easy query generation, fast results, and privacy, ensuring schemas, queries, and credentials are not stored on the service. Users can download results as CSV (Excel support coming soon) and leverage multiple GPT models for generation.
How to Use SQLPilot
- Write your prompt in natural language or specify the tables explicitly to generate the SQL query.
- Choose your model (GPT-3.5, GPT-4, or GPT-4o) and generate the query.
- Review and refine the generated SQL to fit your needs.
- Download results as CSV (Excel support coming soon).
Core Features
- Write SQL from natural language prompts or explicit table references
- Supports PostgreSQL and MySQL (more databases coming soon)
- BYO key: use your own OpenAI key for queries
- Knowledge Base / RAG support: connect your knowledge base to improve output
- Unlimited databases: add as many connections as you need
- Privacy and security: do not store schemas, queries, or credentials
- Download results in CSV format (Excel support coming soon)
- Multiple GPT model support: GPT-3.5, GPT-4, GPT-4o
How It Works
- Connect your database(s) and provide access credentials (not stored).
- Enter a natural-language prompt or specify tables to generate a SQL query using AI.
- The AI suggests a query tailored to your DB type and schema, with options to adjust or optimize.
- Execute locally or download results in CSV; no data is retained by the service beyond the session.
Security and Privacy Considerations
- No storage of schemas, queries, or credentials on the platform.
- Data used for query generation is only what you provide during the session.
- BYO OpenAI key ensures you control access to your API keys.
Supported Databases and Data Access
- PostgreSQL
- MySQL
- More databases to be added soon
Getting Started
- Get started for free with a plan that includes access to AI-powered SQL query generation and multiple GPT models. No credit card required to try the free offering.
FAQs
- What is SQLPilot? An AI-driven SQL query generation and editing tool.
- Can I use my own OpenAI key? Yes, via the BYO Key feature.
- Are my credentials shared? No, credentials are not stored or shared through SQLPilot.
- What data is shared with OpenAI? Only the data you provide during query generation; credentials are not exposed.
What People Are Saying
- Ella Harper: The AI-driven SQL query generation is a game-changer for our team.
- Mason Ray: Incredible tool; it speeds up complex SQL queries significantly.
- Sophia Lee: It’s like having a SQL expert embedded in our workflow.
Pricing and Access
- Get started for free. Experience the power of AI-powered SQL queries with the free plan. No credit card required.