@yuuzu/sql Mcp
About
Set the SQLMCPMODE environment variable to control query permissions. Available modes are safe (default), write, and full. safe mode: allows SELECT, WITH, EXPLAIN (read-only). write mode: adds INSERT, UPDATE, DELETE. full mode: adds CREATE, DROP, ALTER, TRUNCATE. Default mode is…
Details
- Author
- nakiriyuuzu
- Downloads
- 183
- Categories
- Database
Jump to
- 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.
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
@yuuzu/sql McpCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Set the SQL_MCP_MODE environment variable to control query permissions. Available modes are safe (default), write, and full.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"@yuuzu/sql mcp": {
"sql-mcp": {
"command": "bunx",
"args": [
"@yuuzu/sql-mcp"
],
"env": {
"SQL_MCP_MODE": "safe"
}
}
}
}
}McpServers
{
"sql-mcp": {
"command": "bunx",
"args": [
"@yuuzu/sql-mcp"
],
"env": {
"SQL_MCP_MODE": "safe"
}
}
}Query Modes
Control query permissions viaSQL_MCP_MODE environment variable:
| Mode | Allowed Operations | Description |
|------|-------------------|-------------|
| safe (default) | SELECT, WITH, EXPLAIN | Read-only, safest |
| write | + INSERT, UPDATE, DELETE | Allows data modification |
| full | + CREATE, DROP, ALTER, TRUNCATE | Full access, use with caution |Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
