General:

As of 2025-02-23, supports a modern array of backends, including NoSQL databases:
- Big Query
- ClickHouse: clickhouse://[<host>[:port]]/[<database>]
- DuckDB: duckdb:/Users/sspaeti/Documents/duckdbs/playground-v1-1-1.duckdb
- Impala
- jq
- MongoDB
- MySQL
- MariaDB
- Oracle
- osquery
- PostgreSQL: postgresql:///foobar
- Presto
- Redis
- Snowflake
- SQL Server
- SQLite: sqlite:myfile.sqlite3 select count(*) from widgets
- Your own easily implemented adapter

Easily configurable based on a project directory (as seen in rails.vim, for example), rather than just globally or in a per-file modelineFor those that just can’t live without some piece of dbext functionality, the option g:dadbod_manage_dbext is provided to force dbext to use Dadbod’s default database.

E.g. DuckDB

1

duckdb:/Users/sspaeti/Documents/duckdbs/playground-v1-1-1.duckdb

My configs in database.lua:

12345

      vim.g.dbs = {        local_postgres_sspaeti = 'postgres://postgres@localhost:5432/sspaeti',        duckdb_memory = 'duckdb:',        duckdb_file = 'duckdb:///tmp/analytics.duckdb',      }

In Action:

Origin:
References: SQL IDEs
Created 2023-10-19