MCP.so
登录

USQLMCP MCP Server

@thesoulless

基本信息

分类

其他

传输方式

stdio

作者

thesoulless

提交者

Hamed Nemati

关于 USQLMCP MCP Server

A universal SQL MCP (Model Context Protocol).

USQLMCP MCP Server 配置

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

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

USQLMCP MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表,不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 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

常见问题

1

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`).

2

How do I pass database credentials?

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

3

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.

4

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.

5

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`.

评论

其他 分类下的更多 MCP 服务器