📌Overview

Purpose: The Cursor DB MCP Server facilitates access to SQLite databases in Cursor IDE, enabling AI assistants to interact with project data efficiently.

Overview: This server is built on the Model Context Protocol (MCP) and allows users to explore and utilize their Cursor project's data, chat history, and composer information seamlessly.

Key Features:

• Project Database Access: Exposes SQLite databases from Cursor projects to AI assistants, enabling queries for project-related data.

• Chat History Retrieval: Allows users to access and review chat history associated with their projects, enhancing knowledge retention and analysis capabilities.

---

Cursor DB MCP Server

A Model Context Protocol (MCP) server for accessing Cursor IDE's SQLite databases. This server allows AI assistants to explore and interact with Cursor's project data, chat history, and composer information.

Prerequisites

• Cursor IDE

Installation

Easy Installation

Use the provided installation script to install all dependencies:

python install.py

This script will install the basic MCP server and dependencies.

Using with Cursor IDE

1. Open Cursor and navigate to Settings -> Cursor Settings -> MCP.
2. Click: Add new MCP server
3. Name: Cursor DB MCP; Type: Command
4. Command: <fully qualified path to>uv run --with mcp[cli] mcp run <fully qualified path to>/cursor-db-mcp-server.py

Now you can ask questions about the database or retrieve info about historical chats.

Using with Claude Desktop

Add this to your claude_desktop_config.json file:

"cursor-db-mcp": {
  "command": "<fully qualified path to >/uv",
  "args": [
    "run",
    "--with",
    "mcp[cli]",
    "mcp",
    "run",
    "<fully qualified path to >/cursor-db-mcp-server.py"
  ]
}

Available Resources

• cursor://projects - List all available Cursor projects
• cursor://projects/detailed - List projects with detailed information
• cursor://projects/{project_name}/chat - Get chat data for a specific project
• cursor://projects/{project_name}/composers - Get composer IDs for a specific project
• cursor://composers/{composer_id} - Get data for a specific composer

Available Tools

• query_table - Query a specific table in a project's database
• refresh_databases - Refresh the list of database paths

How It Works

The server scans your Cursor installation directory to find project databases (state.vscdb files). It then exposes these databases through MCP resources and tools, allowing AI assistants to query and analyze the data.

Notes

1. Cursor stores AI conversations in different places. Increasingly, chats are stored as "composerData" under globalStorage/state.vscdb. If you don't get results when asking about chats for recent projects, try asking for composers.
2. This was written on a Mac. Your experience may vary on other operating systems.

Shameless Plug

Like this? Try Cursor Journal to create DevLogs directly from Cursor chat history:
https://medium.com/@jbdamask/building-cursor-journal-with-cursor-77445026a08c

License

MIT