SQL database exploration with agent-sql

agent-sql is a read-only-by-default SQL CLI on $PATH. Supports PostgreSQL, CockroachDB, MySQL, MariaDB, SQLite, DuckDB, Snowflake, and MSSQL.

Output goes to stdout as NDJSON by default: query results and lists (schema tables/indexes/constraints, connection list, credential list, config list-keys) are one JSON object per line with no envelope; single resources and receipts (describe, count, test, write receipts) are one compact JSON line. --format json gives pretty JSON (lists wrapped in {"data": [...]}); --format yaml gives YAML. Errors go to stderr as { "error": "...", "fixable_by": "agent|human|retry", "hint": "..." } with non-zero exit; advisories are { "notice": "...", "hint": "..." } lines on stderr.

Quick start

Use -c with a file path, URL, or saved alias -- no setup needed for ad-hoc queries: