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.