Skip to main content
Glama

MCP SQL Server

by ryudg

MCP SQL Server

Version License Node TypeScript

A Model Context Protocol server that provides comprehensive access to SQL databases, starting with MSSQL support. This server enables AI assistants to inspect database schemas, execute queries, and perform database operations with enterprise-grade security and performance monitoring.

Current Status: MSSQL fully supported. MySQL and PostgreSQL support coming in future releases.

✨ Key Features

  • Database Support: Full MSSQL support (MySQL and PostgreSQL coming soon)

  • Schema Inspection: Comprehensive database structure analysis and metadata extraction

  • Query Execution: Safe SQL execution with parameterized queries and result formatting

  • Performance Monitoring: Real-time metrics, query statistics, and performance reports

  • Security First: SQL injection prevention, connection encryption, and access controls

  • Batch Operations: Efficient bulk query execution and transaction management

  • Connection Pooling: Optimized connection management with configurable pool settings

  • MCP Integration: Native support for Claude Desktop, Cursor, and other MCP-compatible tools

📦 Installation & Setup

Prerequisites

  • Node.js 18.0.0+ - Download here

  • Database Server: Microsoft SQL Server (MSSQL)

  • AI Assistant: Claude Desktop, Cursor, or any MCP-compatible tool

Note: Currently only MSSQL is supported. MySQL and PostgreSQL support will be added in future releases.

Quick Installation

# Install globally via NPM npm install -g @donggyunryu/mcp-sql

Basic Configuration

Refer to env.example

Create a .env file with your database settings:

# Create .env file with your database settings # DB_TYPE=mssql # Current only MSSQL supported DB_HOST=localhost DB_PORT=1433 DB_DATABASE=your_database DB_USER=your_username DB_PASSWORD=your_password DB_ENCRYPT=false DB_TRUST_SERVER_CERTIFICATE=true

Test Connection

# Test your database connection npm run test:db # in local environment #or npx @donggyunryu/mcp-sql test:db

🚀 Quick Start

Local Environment

  1. Clone the repository:

    git clone https://github.com/ryudg/mcp-sql.git cd mcp-sql
  2. Install dependencies

    npm install
  3. Build the project

    npm run build
  4. Add to your mcp.json or setting.json, claude_desktop_config.json

    { "mcpServers": { "mcp-sql": { "command": "node", "args": ["/full/path/to/mcp-mysql/build/index.js"], "env": { // "DB_TYPE": "mssql", # Current only MSSQL supported "DB_SERVER": "localhost", "DB_PORT": "1433", "DB_DATABASE": "your_database", "DB_USER": "your_username", "DB_PASSWORD": "your_password", "DB_ENCRYPT": "false", "DB_TRUST_SERVER_CERTIFICATE": "true", "NODE_ENV": "development", "LOG_LEVEL": "info" } } } }

Configure AI Assistant

For Claude Desktop:

Add to your claude_desktop_config.json:

{ "mcpServers": { "mcp-sql": { "command": "npx", "args": ["-y", "@donggyunryu/mcp-sql"], "env": { // "DB_TYPE": "mssql", # Current only MSSQL supported "DB_HOST": "localhost", "DB_PORT": "1433", "DB_DATABASE": "your_database", "DB_USER": "your_username", "DB_PASSWORD": "your_password", "DB_ENCRYPT": "false", "DB_TRUST_SERVER_CERTIFICATE": "true" } } } }

For Cursor(VSCode, Windsurf... etc IDE):

Add to your MCP settings:

{ "mcpServers": { "mcp-sql": { "command": "npx", "args": ["-y", "@donggyunryu/mcp-sql"], "env": { // "DB_TYPE": "mssql", # Current only MSSQL supported "DB_HOST": "localhost", "DB_PORT": "1433", "DB_DATABASE": "your_database", "DB_USER": "your_username", "DB_PASSWORD": "your_password", "DB_ENCRYPT": "false", "DB_TRUST_SERVER_CERTIFICATE": "true" } } } }

Start Using

Restart your AI assistant and try:

"Show me all tables in my database" "What's the structure of the users table?" "Find all active users from the last 30 days"

💬 Usage Examples

Schema Exploration

"Show me all tables in the database" "What's the structure of the users table?" "List all columns in the orders table with their data types"

Data Queries

"Find all active users registered in the last 30 days" "Show me the top 10 customers by total order value" "Get all pending orders from this month"

Performance Monitoring

"Show me current connection pool status" "What are the slowest queries in the last hour?" "Generate a performance report for today"

🛠️ Available Tools

The MCP SQL server provides the following tools for database interaction:

Schema & Discovery Tools

Tool

Description

Parameters

list_tables

List all tables in database

pattern

(optional): Filter pattern

describe_table

Get detailed table structure

table_name

: Name of table to describe

get_schema

Get complete database schema

include_system_tables

: Include system tables

get_schema_statistics

Get schema statistics information

None

Query Execution Tools

Tool

Description

Parameters

execute_query

Execute SQL queries safely

query

: SQL statement

parameters

: Bind parameters

start_batch_processing

Process multiple queries in batch

queries

: Array of SQL statements

Performance & Monitoring Tools

Tool

Description

Parameters

get_connection_pool_status

Get database connection pool status

None

get_query_stats

Get query execution statistics

period

: Time period (optional)

start_performance_monitoring

Start performance monitoring

interval

: Monitoring interval (ms)

generate_performance_report

Generate performance analysis report

timeRange

: Report period

clear_caches

Initialize cache data

None

🛡️ Security

  • Connection Encryption: TLS/SSL connection support

  • Parameter Binding: SQL injection prevention

  • Access Control: Database user permission-based control

  • Logging: Complete query execution logging

  • Input Validation: Comprehensive input sanitization

Security Best Practices

  • Use dedicated database users with minimal required permissions

  • Enable SSL/TLS encryption for database connections when possible

  • Use connection pooling with appropriate limits

  • Never commit credentials to version control

  • Use environment variables for all sensitive configuration

🗺️ Roadmap

Upcoming Features

  • 🔮 Multi-Database Support

    • MySQL adapter implementation

    • PostgreSQL adapter implementation

    • Unified database interface

  • ⚡ Performance & Caching

    • Query result caching system

    • Advanced performance optimization

    • Connection pool enhancements

  • 🧪 Testing & Quality

    • Comprehensive test coverage (100%)

    • Automated CI/CD pipeline

    • Performance benchmarking

  • 🚀 Advanced Features

    • GraphQL integration support

    • Enhanced monitoring dashboard

    • Plugin architecture for extensibility

  • 📊 Analytics & Insights

    • Advanced query analytics

    • Database performance insights

    • Usage statistics and reporting

View CHANGELOG

Support & Community

📝 License

This project is licensed under the MIT License. See the LICENSE file for details.


Made with for the AI-powered development community

MCP SQL Server v1.0.0 - Bridging AI and databases

-
security - not tested
A
license - permissive license
-
quality - not tested

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

A Model Context Protocol server that provides AI assistants with comprehensive access to SQL databases, enabling schema inspection, query execution, and database operations with enterprise-grade security.

  1. ✨ Key Features
    1. 📦 Installation & Setup
      1. Prerequisites
      2. Quick Installation
      3. Basic Configuration
      4. Test Connection
    2. 🚀 Quick Start
      1. Local Environment
      2. Configure AI Assistant
      3. Start Using
    3. 💬 Usage Examples
      1. Schema Exploration
      2. Data Queries
      3. Performance Monitoring
    4. 🛠️ Available Tools
      1. Schema & Discovery Tools
      2. Query Execution Tools
      3. Performance & Monitoring Tools
    5. 🛡️ Security
      1. Security Best Practices
    6. 🗺️ Roadmap
      1. Upcoming Features
    7. Support & Community
      1. 📝 License

        Related MCP Servers

        • -
          security
          A
          license
          -
          quality
          A Model Context Protocol server that enables secure and structured interaction with Microsoft SQL Server databases, allowing AI assistants to list tables, read data, and execute SQL queries with controlled access.
          Last updated -
          48
          MIT License
          • Linux
          • Apple
        • A
          security
          A
          license
          A
          quality
          A Model Context Protocol server that enables secure interaction with Microsoft SQL Server databases, allowing AI assistants to list tables, read data, and execute SQL queries through a controlled interface.
          Last updated -
          238
          MIT License
          • Linux
          • Apple
        • -
          security
          A
          license
          -
          quality
          A Model Context Protocol server implementation that enables AI assistants to execute SQL queries and interact with SQLite databases through a structured interface.
          Last updated -
          7
          MIT License
        • A
          security
          A
          license
          A
          quality
          A Model Context Protocol server that enables AI assistants (Cursor, Windsurf, Claude Code) to interact with Microsoft SQL Server databases by providing connectivity through environment-configurable connections.
          Last updated -
          8
          19
          2
          MIT License

        View all related MCP servers

        MCP directory API

        We provide all the information about MCP servers via our MCP API.

        curl -X GET 'https://glama.ai/api/mcp/v1/servers/ryudg/mcp-sql'

        If you have feedback or need assistance with the MCP directory API, please join our Discord server