mcp-sqlite

A Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities. It exposes complete CRUD operations (create, read, update, delete) along with database exploration and introspection and the ability to execute custom SQL queries. Tools include db_info for database details, list_tables, get_table_schema, and record operations such as create_record and read_records with optional filtering, limit, and offset. The server is configured in an IDE’s MCP settings (for example Cursor or VSCode) by running it via npx with the path to a SQLite database file passed as an argument.

Setup

Define the command in your IDE’s MCP Server settings:

e.g. Cursor:

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

e.g. VSCode:

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

Your database path must be provided as an argument.