DB Pilot

DB Pilot – All Your Data in One App is a database GUI client and SQL editor supporting PostgreSQL, MySQL, SQLite, DuckDB, CockroachDB, and more. It combines a feature-rich editor, AI-assisted querying, and intuitive UI to manage, query, and explore databases ranging from small projects to large-scale schemas. It emphasizes ease of use (spreadsheet-like editing, context-aware autocompletion) while expanding capabilities with AI and multi-database support.

---

How It Works

• Connect to supported databases (PostgreSQL, CockroachDB, MySQL, SQLite, DuckDB, and more coming soon).
• Use the SQL AI Assistant (powered by GPT-4o and GPT-4o mini) to write, explain, and debug queries in plain English.
• Rely on smart autocomplete to get context-aware suggestions for tables, columns, keywords, and functions.
• Edit data directly in a spreadsheet-like interface: insert, update, delete rows with filters to locate specific records without writing SQL.
• Query local or remote files (CSV, JSON) using chDB or DuckDB for quick data exploration.
• Access a schema editor to modify database structure without writing SQL (create tables, add columns, etc.).
• Preview and navigate large schemas with support for many tables and relationships.

---

Supported Databases

• PostgreSQL
• CockroachDB
• MySQL
• SQLite
• DuckDB
• And more coming soon

---

How to Use DB Pilot

1. Download and install the app on macOS (M chip or Intel), with Windows and Linux support coming soon.
2. Connect to your database using your connection details.
3. Use the AI Assistant to write or explain SQL queries—simply describe what you want in English.
4. Edit data with the spreadsheet-like editor or run SQL directly.
5. Query files (CSV/JSON) locally or remotely via chDB/DuckDB for quick data access.
6. Open the Schema Editor to modify table structures without SQL.

---

Roadmap & Pricing

• Continuous expansion of database support
• Desktop availability across Windows and Linux (soon)
• Pricing options include a monthly subscription and a one-time license for premium features (AI assistant included; updates for 1 year with license)

---

Safety & Data Handling

• The AI assistant helps with writing and explaining queries but does not read your actual data. It understands existing tables and columns to assist, without accessing stored data.

---

Core Features

• Multi-database GUI client: PostgreSQL, CockroachDB, MySQL, SQLite, DuckDB, and more
• SQL AI Assistant (GPT-4o/GPT-4o mini): write, debug, and understand queries
• Smart autocomplete with context-aware suggestions for tables, columns, keywords, and functions
• Spreadsheet-style data editing: insert/update/delete rows
• Filters to search data without writing SQL
• Query CSV, JSON, and other local/remote files via chDB or DuckDB
• Schema Editor to modify database structure without SQL
• Cross-database support with a unified UI and workflow
• Desktop-ready: macOS (M chip and Intel), with Windows/Linux support planned

---

Pricing (Summary)

• Subscription: $20 per month for premium features and AI assistant access
• One-time purchase: $79 (lifetime updates for 1 year; includes AI assistant with own OpenAI API key and updates for 1 year)

Note: This description reflects the product’s capabilities and roadmap as provided; exact features and pricing may evolve over time.