@yuuzu/sql Mcp

@nakiriyuuzu

About @yuuzu/sql Mcp

## Query Modes

Config

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

{
  "mcpServers": {
    "sql-mcp": {
      "command": "bunx",
      "args": [
        "@yuuzu/sql-mcp"
      ],
      "env": {
        "SQL_MCP_MODE": "safe"
      }
    }
  }
}

Tools

No tools detected

Fetch the live tool list by running this server in a temporary sandbox using the button above.

Overview

What is @yuuzu/sql MCP?

—

How to use @yuuzu/sql MCP?

Set the SQL_MCP_MODE environment variable to control query permissions. Available modes are safe (default), write, and full.

Key features of @yuuzu/sql MCP

safe mode: allows SELECT, WITH, EXPLAIN (read-only).
write mode: adds INSERT, UPDATE, DELETE.
full mode: adds CREATE, DROP, ALTER, TRUNCATE.
Default mode is safe if no variable is set.

Use cases of @yuuzu/sql MCP

Running read‑only queries with the safe mode.
Modifying data with INSERT, UPDATE, DELETE in write mode.
Performing full schema changes (CREATE, DROP, ALTER, TRUNCATE) in full mode.

FAQ from @yuuzu/sql MCP

What query modes are available?

Three modes: safe, write, and full.

What operations are allowed in `safe` mode?

Only SELECT, WITH, and EXPLAIN statements.

How do I enable the `write` or `full` mode?

Set the environment variable SQL_MCP_MODE to write or full before starting the server.

What is the default mode if I don't set the variable?

The default mode is safe.

Is there a transport or authentication method described?

—

Frequently asked questions

What query modes are available?

Three modes: `safe`, `write`, and `full`.

What operations are allowed in `safe` mode?

Only SELECT, WITH, and EXPLAIN statements.

How do I enable the `write` or `full` mode?

Set the environment variable `SQL_MCP_MODE` to `write` or `full` before starting the server.

What is the default mode if I don't set the variable?

The default mode is `safe`.

Comments

Basic information

More Databases MCP servers

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K