Key features of DB Pilot include:
- Integrated OLAP database to connect all data sources
- Ability to attach databases, local files, and files on S3
- Query across multiple sources and join tables
- Query local and remote files (CSV, JSON, Parquet) with SQL
- AI assistant, DB Pilot AI, for writing queries and debugging errors
- Support for popular databases such as PostgreSQL, MySQL, SQLite, and DuckDB
- Spreadsheet-like editor for easy data manipulation
- Query history and schema editor (coming soon)