sqlite3
agent-ready json output non-interactive
The most widely deployed database engine, with a powerful CLI. Perfect for local data storage, analysis, and prototyping.
How to install sqlite3
brew install sqlite When to use sqlite3
- Quickly analyze or transform local data files (e.g., CSV, JSON) using SQL queries without setting up a server.
- Prototype a database schema or test SQL queries for an application during development.
- Perform ad-hoc data exploration or generate reports from small to medium datasets (e.g., under a few GB).
When not to use sqlite3
- When the application requires high concurrency or multiple simultaneous writers (SQLite uses file-level locking).
- For deploying as a production database for large-scale, high-traffic web applications (consider PostgreSQL, MySQL, etc.).
sqlite3 features
- · Zero-config database
- · JSON output mode
- · CSV import/export
- · Full SQL support
- · In-memory databases
Want your agent to find this automatically?
Add the MCP server to your agent config and it will discover tools like sqlite3 on its own.
Set up MCP →