Chat with Database

Summary

The Chat with Database Agent answers questions about your data in plain English. It introspects the schema, writes the SQL, runs it read-only, and explains the results. Reach for it to give non-SQL users a safe way to query a database, or to prototype analytics without hand-writing queries.

Install

bunnpmpnpmyarn
$ pnpm dlx shadcn@latest add @agentcn/eve/text-to-sql
Copy

Composition

Copyagent/
├── agent.ts                   # Agent definition (model + config)
├── instructions.md            # Introspect → SQL → execute instructions
├── lib/
│   └── db.ts                  # Database client (SQLite by default)
└── tools/
    ├── introspect_schema.ts   # Lists tables and columns
    └── run_query.ts           # Runs a read-only SELECT

Customization

• Swap the database. Replace the client in lib/db.ts with Postgres or MySQL.
• Allow writes (carefully). The run_query tool blocks non-SELECT SQL by default — relax that only behind explicit confirmation.
• Add row limits. Cap result size in run_query to protect against huge scans.
• Swap the model. Edit agent/agent.ts.