USQLMCP

Name: USQLMCP
Author: thesoulless

@thesoulless

代码仓库

关于 USQLMCP

A universal SQL MCP (Model Context Protocol).

#sql #database

基本信息

分类

其他

传输方式

stdio

发布者

thesoulless

提交者

Hamed Nemati

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is USQLMCP?

USQLMCP is a universal SQL MCP (Model Context Protocol) server that enables AI assistants to execute SQL queries against a wide range of database systems. It leverages the usql library to support many databases (SQLite, PostgreSQL, MySQL, etc.) and exposes three tool calls (read_query, write_query, create_table) for read, write, and schema‑creation operations.

How to use USQLMCP?

Download the pre‑built binary for your platform from the Releases page and place it on your PATH, or run it via Docker. Then configure your MCP client (e.g., Cursor) to launch USQLMCP with a --dsn argument specifying the target database connection string. The server automatically provides the read_query, write_query, and create_table tools to the client.

Key features of USQLMCP

read_query tool for executing SELECT queries
write_query tool for INSERT, UPDATE, DELETE, ALTER
create_table tool for defining new tables
Supports any database engine usable via usql (SQLite, PostgreSQL, MySQL, etc.)
Runs over stdio transport; works with any MCP‑compatible client
Single‑binary release or Docker image for easy deployment

Use cases of USQLMCP

AI‑powered natural‑language querying of a live database
Automated schema migrations via create_table and write_query
Read‑only data exploration for BI assistants
Database administration tasks triggered from a chat interface

FAQ from USQLMCP

What databases does USQLMCP support?

Any database that the usql library supports, including SQLite, PostgreSQL, MySQL, SQL Server, Oracle, and many others. You specify the database via the --dsn argument (e.g., sqlite3:///path/to/db.db or postgres://user:pass@host/db).

How do I pass database credentials?

Credentials are embedded directly in the DSN string, for example postgres://username:password@host:5432/dbname?sslmode=disable.

Does USQLMCP require a separate installation of usql?

No. The release binary is self‑contained and includes the usql dependency. Docker images also bundle everything needed.

Can I run USQLMCP as a standalone server?

USQLMCP uses the stdio transport, meaning it is meant to be launched and managed by an MCP client (such as Cursor). It is not a long‑running HTTP server.

How do I use USQLMCP with a SQLite file in Docker?

Mount the SQLite database file into the container and point the DSN to the mounted path, for example: -v /local/path.db:/data/db.db --dsn sqlite3:///data/db.db.