DB Pilot

What is DB Pilot?

DB Pilot is a database GUI built on an OLAP system from ClickHouse. It lets you query multiple data sources — PostgreSQL, S3, CSV, and JSON — as if they were a single database.

Its standout feature is an AI assistant powered by GPT-3.5 and GPT-4 that helps you write, fix, and understand SQL queries. The app also includes a spreadsheet-like editor, context-aware autocomplete, and support for databases such as PostgreSQL, CockroachDB, and MySQL.

Who created DB Pilot?

DB Pilot was developed by a team led by a founder whose details aren’t publicly shared. The company’s goal is to improve data management through features like the ClickHouse-based OLAP system and the GPT-powered AI assistant.

Who is DB Pilot for?

• Professionals who manage databases regularly
• Anyone who works with SQL and data sources

Key Features

• AI assistant: Write, debug, and understand SQL queries; capable of handling databases with thousands of tables.
• Broad database support: Connect to PostgreSQL, CockroachDB, MySQL, SQLite, chDB, and DuckDB.
• Data import: Import from over 250 sources, including Intercom and Mixpanel.
• Smart autocomplete: Context-aware suggestions for tables, columns, keywords, and functions.
• Spreadsheet-like editor: Edit, update, or delete rows directly, and filter data without writing SQL.
• File querying: Query local or remote CSV and JSON files using chDB or DuckDB.

Platform and Pricing

DB Pilot runs on Mac, with Linux and Windows versions planned. Upcoming features include a schema editor for updating database structure without SQL, plus additional database support.

Pricing options:

• Subscription starting at $20 per month
• One-time purchase of $79, which includes access to premium features and the AI assistant