Chat2DB

Chat2DB is an open source SQL client that uses AI to write queries from plain-language requests. It also works as a visual tool for browsing, editing and moving data across many database types.

Chat2DB lets a user type a question in everyday language and get a SQL query in return. The AI reads the table structure, so you can add business terms in column comments to help it write better queries. The tool also includes a SQL editor, a table view for editing data, ER diagrams, and charts built from query results. One desktop client handles connections to many databases.

• Generate SQL from plain-language questions
• One-click fixes for common SQL errors
• Visual editing, sorting and filtering of tables
• Import and export of CSV, XLSX and SQL files
• Connections to many relational and non-relational databases

Data analysts who need answers without writing every query by hand. It also suits backend developers and database administrators who manage several database types and want one client for all of them.

The project is released under the Apache 2.0 license, and the site also has a pricing page. The site says queries are processed locally and that the AI sees only the schema. A desktop client is offered for download, so check that it covers the databases you use.