Private

usqlmcp

See in Github

2025-04-14

A universal SQL MCP (Model Context Protocol).

0

Github Watches

0

Github Forks

0

Github Stars

usqlmcp

A universal SQL MCP (Model Context Protocol).

Features

Tools
- read_query: Execute a SELECT query and return the results.
- write_query: Execute an INSERT, UPDATE, DELETE, or ALTER query and return the number of affected rows.
- create_table: Execute a CREATE TABLE query to define new tables in the database.
- list_tables: Retrieve a list of all table names in the database.
- describe_table: Retrieve schema information for a specific table.
Resources
- schema://all: Get schema information for all tables
- schema://{table}: Get schema information for a specific table

Installing

usqlmcp is available via Release

Installing via Release

Download a release for your platform
Extract the usqlmcp or usqlcmp.exe file from the .tar.bz2 or .zip file
Move the extracted executable to somewhere on your $PATH (Linux/macOS) or %PATH% (Windows)

Setup

MCP Integration in Cursor

Add the following configuration to your ~/.cursor/mcp.json file or configure via the settings menu in Cursor.

{
    "mcpServers": {
        "usqlmcp": {
            "command": "usqlmcp",
            "args": ["--dsn", "sqlite3:///your/db/dsn/file.db"]
        }
    }
}

Other tools

{
    "servers": {
        "usqlmcp": {
            "type": "stdio",
            "command": "usqlmcp",
            "args": ["--dsn", "sqlite3:///your/db/dsn/file.db"]
        }
    }
}