fbanyai/TinyMSSQL-MCP-Server

Tiny MSSQL MCP Server

A Model Context Protocol (MCP) server for Microsoft SQL Server that provides tools to interact with MSSQL databases. Provides basic connection for MCP clients retrieving schemas, tables, indexes and procedures structures.

Features

• List Schemas: Get all schemas in the database
• List Tables: Get all tables in a specific schema
• List Stored Procedures: Get all stored procedures in a schema
• List Functions: Get all functions in a schema
• List Indexes: Get all indexes, optionally filtered by table
• Get Table Details: Get comprehensive table information including columns, indexes, and foreign key relationships

Setup

1. Install dependencies:

npm install

2. Configure your database connection by copying .env.example to .env and updating the values:

cp .env.example .env

3. Build the project:

npm run build

Configuration

Set the following environment variables:

• MSSQL_SERVER: SQL Server hostname (default: localhost). For named instances use format: localhost\SQLEXPRESS
• MSSQL_DATABASE: Database name (default: master)
• MSSQL_USER: SQL Server username for authentication (required)
• MSSQL_PASSWORD: SQL Server password for authentication (required)
• MSSQL_ENCRYPT: Enable encryption (true/false, default: false for local development)
• MSSQL_TRUST_CERT: Trust server certificate (true/false, default: true for local development)

Authentication Requirements

Important: This server currently only supports SQL Authentication. Windows Authentication (MSSQL_TRUSTED_CONNECTION) is not supported as the underlying mssql package with its default tedious driver cannot use integrated Windows Authentication.

To use this server with SQL Server:

1. Ensure SQL Server is configured for Mixed Mode Authentication
2. Create a SQL Server login with username and password
3. Grant appropriate permissions to the database

Testing

You can test the MCP server using the MCP inspector:

$env:MSSQL_SERVER="localhost\SQLEXPRESS"
$env:MSSQL_DATABASE="YourDatabase"
$env:MSSQL_USER="YourUsername"
$env:MSSQL_PASSWORD="YourPassword"
$env:MSSQL_ENCRYPT="false"
$env:MSSQL_TRUST_CERT="true"

npx @modelcontextprotocol/inspector node dist/index.js

Adding to Claude Code

To add this MCP server to Claude Code:

claude mcp add tinymssql -s project node "[FULLPATH]/dist/index.js" `
  --env MSSQL_SERVER="localhost\SQLEXPRESS" `
  --env MSSQL_DATABASE="YourDatabase" `
  --env MSSQL_USER="YourUsername" `
  --env MSSQL_PASSWORD="YourPassword" `
  --env MSSQL_ENCRYPT="false" `
  --env MSSQL_TRUST_CERT="true"

Tools Available

list_schemas

Lists all schemas in the database.

Parameters: None

list_tables

Lists all tables in the specified schema.

Parameters:

• schema (optional): Schema name, defaults to 'dbo'

list_procedures

Lists all stored procedures in the specified schema.

Parameters:

• schema (optional): Schema name, defaults to 'dbo'

list_functions

Lists all functions in the specified schema.

Parameters:

• schema (optional): Schema name, defaults to 'dbo'

list_indexes

Lists all indexes, optionally filtered by table.

Parameters:

• table_name (optional): Filter by specific table
• schema (optional): Schema name, defaults to 'dbo'

get_table_details

Gets comprehensive information about a table.

Parameters:

• table_name (required): Name of the table
• schema (optional): Schema name, defaults to 'dbo'

Returns detailed information including:

• Column definitions with data types, nullability, defaults
• All indexes on the table
• Foreign key relationships