SQL Database MCP Server

A Model Context Protocol (MCP) server that connects to Azure SQL Server databases using Azure AD authentication. Built with the official MCP TypeScript SDK. Run it instantly with npx — no install required.

Tools

Discovery

| Tool | Description | |---|---| | list_databases | List all accessible databases on each configured SQL Server | | list_tables | List all user tables with schema and row count | | list_views | List all views with schema, name, and whether indexed | | list_stored_procedures | List all stored procedures with parameter count and last modified date | | search_objects | Search for any object (table, view, procedure, function, trigger) by name pattern |

Schema & Structure

| Tool | Description | |---|---| | get_table_schema | Get column details (name, type, length, nullability) for a table | | get_indexes | List all indexes on a table with columns, uniqueness, and included columns | | get_foreign_keys | Show all foreign key relationships (outgoing and incoming) for a table | | get_stored_procedure_definition | Get the full CREATE PROCEDURE source code |

Analysis

| Tool | Description | |---|---| | get_object_dependencies | Show what a given object references and what references it (impact analysis) | | find_column_references | Find every table, view, procedure, and function that defines or uses a column | | execute_query | Execute an arbitrary SQL query and return formatted results |

Authentication

The server uses Azure AD (Entra ID) with the device code flow. On first use, you'll be prompted to sign in via a browser. Your credentials are cached for future sessions.

Quick Start

Usage with Cursor / Claude Desktop

Add the following to your MCP server configuration:

{
  "mcpServers": {
    "sql-database": {
      "command": "npx",
      "args": ["-y", "sql-database-mcp-server"],
      "env": {
        "SQL_SERVERS": "server1.database.windows.net,server2.database.windows.net"
      }
    }
  }
}

For a specific Azure AD tenant (e.g. single-tenant apps):

{
  "mcpServers": {
    "sql-database": {
      "command": "npx",
      "args": ["-y", "sql-database-mcp-server"],
      "env": {
        "SQL_SERVERS": "yourserver.database.windows.net",
        "SQL_TENANT_ID": "your-tenant-id"
      }
    }
  }
}

Environment Variables

| Variable | Required | Description | |---|---|---| | SQL_SERVERS | Yes | Comma-separated list of SQL Server hostnames (e.g. server1.database.windows.net,server2.database.windows.net). Optional port: host:1433 | | SQL_TENANT_ID | No | Azure AD tenant ID. Omit for multi-tenant / default tenant |

Requirements

• Node.js >= 18
• Azure SQL Server instance(s)
• Azure AD account with access to the target databases