USQLMCP

Name: USQLMCP
Author: thesoulless

@thesoulless

Repository

About USQLMCP

A universal SQL MCP (Model Context Protocol).

#sql #database

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.

Comments

More Other MCP servers

Inbox Zero AI MCP

elie222

The world's best AI personal assistant for email. Open source app to help you reach inbox zero fast.

11.6K

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K