Provides tools for connecting to and interacting with PostgreSQL databases, allowing users to list databases and tables, inspect schemas, and execute SQL queries with configurable permission modes (safe, write, or full).
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@sql-mcpShow me the schema for the customers table"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
@yuuzu/sql-mcp
A Model Context Protocol (MCP) server for MSSQL and PostgreSQL database operations.
Installation
# Using bunx (recommended)
bunx @yuuzu/sql-mcp
# Using npx
npx @yuuzu/sql-mcpFeatures
Multi-database support: MSSQL and PostgreSQL
8 tools for database operations
Three query modes: safe, write, full
Advanced authentication: Windows Auth (MSSQL), SSL certificates (PostgreSQL)
Tools
Tool | Description |
| Connect to a database server |
| Disconnect from the current connection |
| Check connection status and query mode |
| List all databases on the server |
| Switch to a different database |
| List all tables and views |
| Get table schema details |
| Execute SQL queries |
Query Modes
Control query permissions via SQL_MCP_MODE environment variable:
Mode | Allowed Operations | Description |
| SELECT, WITH, EXPLAIN | Read-only, safest |
| + INSERT, UPDATE, DELETE | Allows data modification |
| + CREATE, DROP, ALTER, TRUNCATE | Full access, use with caution |
# Example: Enable write mode
SQL_MCP_MODE=write bunx @yuuzu/sql-mcpUsage Examples
Claude Desktop Configuration
Add to your claude_desktop_config.json:
{
"mcpServers": {
"sql-mcp": {
"command": "bunx",
"args": ["@yuuzu/sql-mcp"],
"env": {
"SQL_MCP_MODE": "safe"
}
}
}
}Connect to MSSQL
{
"tool": "connect-database",
"arguments": {
"engine": "mssql",
"server": "localhost",
"port": 1433,
"user": "sa",
"password": "your_password",
"database": "master"
}
}Connect to PostgreSQL
{
"tool": "connect-database",
"arguments": {
"engine": "postgres",
"server": "localhost",
"port": 5432,
"user": "postgres",
"password": "your_password",
"database": "postgres"
}
}Connect with Windows Authentication (MSSQL)
{
"tool": "connect-database",
"arguments": {
"engine": "mssql",
"server": "localhost",
"windowsAuth": true
}
}Connect with SSL (PostgreSQL)
{
"tool": "connect-database",
"arguments": {
"engine": "postgres",
"server": "your-server.com",
"user": "postgres",
"password": "your_password",
"ssl": {
"rejectUnauthorized": true,
"ca": "/path/to/ca-certificate.crt"
}
}
}Development
# Install dependencies
bun install
# Run in development mode
bun run dev
# Run tests
bun test
# Run tests with coverage
bun test --coverage
# Build
bun run build
# Type check
bun run typecheckRelease
Releases are automated via GitHub Actions. To create a new release:
# Create and push a version tag
git tag v1.0.0
git push origin v1.0.0This will:
Build the project
Publish to npm with provenance
Create a GitHub Release with auto-generated release notes
Requirements: Set NPM_TOKEN secret in your GitHub repository settings.
License
MIT
This server cannot be installed
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.