Analyze files locally
Import CSV, Parquet or JSON, or the result of any query, into embedded DuckDB and join them with SQL.
omni-sql documentation
An open-source SQL IDE with local DuckDB analysis for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle and MongoDB.
One editor, many databases
Metadata- and CTE-aware completion, quick fixes and execution plans for six databases, plus experimental JDBC and ODBC.
Connections that scale
Folders, custom environments, and import from DBeaver. Passwords stay in the OS keyring.
AI assistants, with approval
A local MCP server for Codex, Claude Desktop and ChatGPT Desktop. Every edit and execution waits for you.
Where to go next
Section titled “Where to go next”InstallationPackages for Windows, Linux and macOS.
Getting startedFrom a file or a connection to your first query.
Local analysisImports, samples, S3, exports and provenance.
MCP integrationConnect an AI client safely.