mcp-sqlite

This MCP server provides a streamlined interface to interact with a SQLite database. It exposes tools for database introspection, table operations, record CRUD actions, and the ability to run custom SQL queries. The available tools let you browse the database schema, list tables, view individual table schemas, and create, read, update, and delete records with configurable conditions and limits. You can also execute arbitrary SQL commands, returning results for analysis or integration with other tooling. To use it, run the server via your IDE’s MCP settings (typically by invoking the MCP SQLite Server with the path to your SQLite database), then issue tool calls through the provided JSON-RPC interface to perform operations against your database.

Prerequisites:

• Node.js and npm or npmx available on your system
• Access to a SQLite database file

Installation steps:

1. Ensure you have Node.js installed. If not, download from https://nodejs.org and install.

2. Use npx to run the MCP SQLite server directly without local installation:

   npx -y mcp-sqlite <path-to-your-sqlite-database.db>

3. In your MCP client configuration (IDE settings), reference the same command and arguments as shown:

   { "mcpServers": { "MCP SQLite Server": { "command": "npx", "args": [ "-y", "mcp-sqlite", "<path-to-your-sqlite-database.db>" ] } } }

4. Start the server from your IDE and connect to it using the MCP tooling to begin issuing tool calls.

Tips and notes:

• The database path must be provided as the last argument when starting the server.
• Available tools include: db_info, list_tables, get_table_schema, create_record, read_records, update_records, delete_records, and query for custom SQL.
• Use appropriate condition objects to filter reads and updates, and set limit/offset to page through results.
• Ensure the SQLite database file is accessible by the process running the MCP server (permissions and path correctness are common issues).
• The server integrates with the sqlite3 library; if you encounter SQL syntax or type issues, verify compatibility with your SQLite version.