SQLite MCP server

The SQLite MCP Server provides database interaction and business intelligence capabilities through SQLite, allowing you to run SQL queries, analyze business data, and automatically generate business insight memos through the Model Context Protocol (MCP).

Installation Options

Using uv

To add the SQLite MCP server to your Claude Desktop configuration:

1. Locate your claude_desktop_config.json file
2. Add the server configuration to the mcpServers section:

"mcpServers": {
  "sqlite": {
    "command": "uv",
    "args": [
      "--directory",
      "parent_of_servers_repo/servers/src/sqlite",
      "run",
      "mcp-server-sqlite",
      "--db-path",
      "~/test.db"
    ]
  }
}

Make sure to adjust the paths according to your system setup.

Using Docker

If you prefer using Docker:

1. Add the following configuration to your claude_desktop_config.json file:

"mcpServers": {
  "sqlite": {
    "command": "docker",
    "args": [
      "run",
      "--rm",
      "-i",
      "-v",
      "mcp-test:/mcp",
      "mcp/sqlite",
      "--db-path",
      "/mcp/test.db"
    ]
  }
}

2. Build the Docker image:

docker build -t mcp/sqlite .

Features and Capabilities

Available Resources

The server provides one dynamic resource:

• memo://insights: A continuously updated business insights memo that aggregates discovered insights during your data analysis sessions

Interactive Prompt

The server includes a demonstration prompt:

• mcp-demo: Guides you through database operations
  • Requires a topic argument specifying the business domain to analyze
  • Automatically generates appropriate database schemas and sample data
  • Helps you analyze data and generate insights
  • Integrates with the business insights memo

Using the Tools

Query Tools

Reading Data

Use the read_query tool to execute SELECT queries:

-- Example: Get all customers
SELECT * FROM customers

Input parameters:

• query (string): Your SELECT SQL query

Returns: Query results as an array of objects

Writing Data

Use the write_query tool for INSERT, UPDATE, or DELETE operations:

-- Example: Add a new customer
INSERT INTO customers (name, email) VALUES ('Jane Doe', '[email protected]')

Input parameters:

• query (string): Your SQL modification query

Returns: { affected_rows: number }

Creating Tables

Use the create_table tool to set up new database tables:

-- Example: Create a products table
CREATE TABLE products (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  price REAL,
  category TEXT
)

Input parameters:

• query (string): CREATE TABLE SQL statement

Returns: Confirmation of table creation

Schema Tools

Listing Tables

Use the list_tables tool to view all tables in your database:

list_tables

No input required. Returns an array of table names.

Describing Tables

Use the describe-table tool to examine a table's structure:

describe-table products

Input parameters:

• table_name (string): Name of the table to describe

Returns: Array of column definitions with names and types

Analysis Tools

Adding Insights

Use the append_insight tool to add business insights to the memo resource:

append_insight "Sales in the western region have increased by 15% quarter-over-quarter"

Input parameters:

• insight (string): The business insight discovered from your data analysis

Returns: Confirmation of insight addition Updates the memo://insights resource automatically

How to add this MCP server to Cursor

There are two ways to add an MCP server to Cursor. The most common way is to add the server globally in the ~/.cursor/mcp.json file so that it is available in all of your projects.

If you only need the server in a single project, you can add it to the project instead by creating or adding it to the .cursor/mcp.json file.

Adding an MCP server to Cursor globally

To add a global MCP server go to Cursor Settings > MCP and click "Add new global MCP server".

When you click that button the ~/.cursor/mcp.json file will be opened and you can add your server like this:

{
    "mcpServers": {
        "cursor-rules-mcp": {
            "command": "npx",
            "args": [
                "-y",
                "cursor-rules-mcp"
            ]
        }
    }
}

Adding an MCP server to a project

To add an MCP server to a project you can create a new .cursor/mcp.json file or add it to the existing one. This will look exactly the same as the global MCP server example above.

How to use the MCP server

Once the server is installed, you might need to head back to Settings > MCP and click the refresh button.

The Cursor agent will then be able to see the available tools the added MCP server has available and will call them when it needs to.

You can also explictly ask the agent to use the tool by mentioning the tool name and describing what the function does.