SQLite MCP
Lightweight MCP server enabling AI to perform CRUD operations on SQLite databases
MCP server providing SQLite database connectivity. Allows AI to create tables, manipulate data, and execute queries against local SQLite files.
Author: Anthropic
Stars: 4,200
GitHub
Install: npx -y @modelcontextprotocol/server-sqlite --db-path /path/to/db.sqlite
Key Features
- Execute SQL queries and retrieve results
- Create, delete, and manage table schemas
- Insert, update, and delete data records
- Direct access to local SQLite database files
- Execute JOIN queries across multiple tables
Use Cases
- Data analysis assistant — AI extracts data from local database and generates analysis results autonomously.
- Application development support — Design and manage SQLite databases interactively during development with auto-generated test data.
- Business data management — Query customer and sales data through AI to automatically generate reports and statistics.
- Backup data retrieval — Search and restore needed information from locally stored backup databases.