sqltool

Overview ¶

Package sqltool provides SQL database query tools for agents. It enables agents to query PostgreSQL, MySQL, and SQLite databases using SQL, making structured data accessible through natural language workflows.

Problem: Agents frequently need to answer data questions like "how many users signed up this week?" or "what's the average order value?" Without this tool, agents cannot access relational databases and must rely on stale training data or ask humans to run queries manually.

Safety guards:

• Read-only by default (only SELECT, SHOW, DESCRIBE, EXPLAIN allowed)
• Query timeout (30 seconds) prevents runaway queries
• Output truncated at 32 KB to limit LLM context consumption
• Row limit (1000) prevents massive result sets
• No credentials stored — DSN passed per-request or via config

Dependencies:

• psql CLI (PostgreSQL) — install: brew install postgresql / apt-get install postgresql-client
• mysql CLI (MySQL) — install: brew install mysql-client / apt-get install mysql-client
• sqlite3 CLI (SQLite) — install: brew install sqlite / apt-get install sqlite3
• No Go database drivers required (uses exec-based approach)