Microsoft SQL Server MCP Server (MSSQL)

List all available named database connections configured in the server

Test the database connection and return basic server information

List all databases available on the SQL Server instance

List all tables in the connected database

Get detailed schema information for a specific table including columns, data types, and constraints

Retrieve sample data from a table (top 10 rows by default)

Execute a custom SQL SELECT query with automatic limit (top 20 rows)

Get foreign key relationships between tables in the database

List all stored procedures, functions, and their basic information

Get detailed information about a specific stored procedure including parameters and definition

List all views in the database with their basic information

Get detailed information about a specific view including its definition and dependencies

List all triggers in the database with their associated tables

Get detailed information about a specific trigger including its definition and events

List all user-defined functions (scalar, table-valued, etc.)

List all indexes on tables with usage statistics and detailed information

Get table row counts, size information, and last update statistics

Identify potentially missing indexes based on query execution patterns

Show detailed index usage statistics to identify unused or underutilized indexes

Get comprehensive database size information including data and log file sizes

List all constraints (check, unique, foreign key, etc.) across tables in the database

Extract and analyze business rules from check constraints

List all user-defined data types and their definitions

List computed columns and their formulas to understand derived business logic

List all default value constraints and their definitions

Get data distribution patterns for columns to understand data quality and patterns

Identify reference/lookup tables automatically based on table patterns

Find columns with high null percentages and analyze null patterns

Identify common audit trail patterns (created/modified dates, user tracking)

Get the complete SQL query/definition of a stored procedure - this is the actual source code

Get complete SQL definitions for multiple stored procedures at once

Get complete SQL definitions for all stored procedures in a schema

Search for stored procedures containing specific text or patterns in their SQL definition