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.