GitHub Repository

Lightweight, agent-optimized database CLI with one-shot schema introspection, column profiling, and ERD generation.

6 starsPython

Dbcli – A Lightweight Database CLI Designed for AI Agents

Name: Dbcli – A Lightweight Database CLI Designed for AI Agents
Availability: InStock
Author: justvugg

by justvugg·Mar 3, 2026·1 point·2 comments

Visit Project View on HN

AI Analysis

●●SolidSolve My ProblemBig Brain

One-shot schema dump with column stats beats MCP overhead, but SQL introspection tools already exist.

Strengths

•dbcli snap captures schema, stats, and relationships in single call—genuine token savings for agentic workflows.
•Zero setup (pip install), no server process, works with any shell-capable agent or LLM platform.
•Multi-database support (8+ systems) with optional drivers keeps base install lightweight.

Weaknesses

•Core value (database introspection + profiling) overlaps with pgAdmin, DBeaver, Dataedo; unclear what's fundamentally better.
•MCP comparison is rhetorical—MCP isn't meant for agents with direct shell access; conflates protocol design with use case mismatch.

Post Description

I built dbcli, a lightweight database CLI designed specifically for AI agents that need fast, low-overhead access to relational databases.

The main idea is to make database introspection and querying simple and efficient when an agent has shell access. With a single command (dbcli snap), you can retrieve schema details, table relationships, and basic data profiling (column stats, ranges, cardinality) without stitching together multiple queries or tools. This helps reduce token usage and unnecessary round-trips in agent workflows.

Dbcli supports multiple databases, including PostgreSQL, MySQL, MariaDB, SQLite, DuckDB, ClickHouse, SQL Server, and others via optional drivers. It allows running queries, executing SQL files, and writing data directly from the CLI. There’s no server process or external service required — just install locally with:

pip install -e .

The goal is to provide a simple, agent-agnostic alternative to heavier protocol-based approaches, working with any system capable of executing shell commands.

I’d really appreciate feedback, especially from those building AI agents or tools that require structured database access.

Github repo: https://github.com/JustVugg/dbcli