SQLite MCP Server

SQLite MCP Server

This is a Model Context Protocol (MCP) server that provides access to a SQLite database. It allows AI assistants (like Trae) to query and modify SQLite databases directly.

Features

• Read Queries: Execute SELECT queries to retrieve data.
• Write Queries: Execute INSERT, UPDATE, DELETE queries to modify data.
• Schema Inspection: List tables and describe table schemas.
• Secure: Runs locally on your machine.

Prerequisites

• Python 3.10 or higher
• pip (Python package installer)

Installation

1. Clone or download this repository.
2. Install the required dependencies:

pip install -r requirements.txt

Usage

You can run the server directly from the command line:

python main.py --db path/to/your/database.sqlite

If the database file does not exist, it will be created automatically when you perform a write operation.

Configuration in Trae

To use this MCP server in Trae, you need to add it to your MCP configuration file.

1. Open Trae.
2. Go to Settings -> MCP Servers (or edit the configuration file directly if you know the location, typically ~/.config/trae/config.json or similar depending on OS).
3. Add the following configuration:

{
  "mcpServers": {
    "sqlite": {
      "command": "python",
      "args": [
        "absolute/path/to/sqlite_mcp/main.py",
        "--db",
        "absolute/path/to/your/database.sqlite"
      ]
    }
  }
}

Note:

• Replace absolute/path/to/sqlite_mcp/main.py with the full path to the main.py file in this project.
• Replace absolute/path/to/your/database.sqlite with the full path to your SQLite database file.
• On Windows, use double backslashes \\ or forward slashes / in paths (e.g., "C:\\Users\\Name\\sqlite_mcp\\main.py").

API Documentation

Tools

`read_query`

Executes a SELECT query on the SQLite database.

• Input: query (string) - The SQL SELECT query.
• Output: List of dictionaries representing the rows.

`write_query`

Executes an INSERT, UPDATE, or DELETE query.

• Input: query (string) - The SQL modification query.
• Output: Success message with row count.

`list_tables`

Lists all tables in the database.

• Input: None.
• Output: List of table names.

`describe_table`

Gets the schema for a specific table.

• Input: table_name (string).
• Output: List of column definitions.