This server provides a high-performance MSSQL database management interface through the Model Context Protocol (MCP), leveraging Bun runtime for exceptional speed and offering secure, permission-controlled database operations.

Core Database Operations:

• Connect to MSSQL databases with configurable connection parameters (server, port, credentials, encryption)

• List available user databases and switch between different databases on the same server

• Discover and list tables within the current database

• Inspect database schema by describing table structures, fields, and column information

• Execute SQL queries with optional result limits (default 100 rows)

• Monitor connection status and explicitly disconnect when needed

Security & Permissions:

• Granular permission control via environment variables with four modes: read-only (default), write, full (insert/update/delete), and danger mode

• Secure connection options including encryption and authentication controls

Performance & Integration:

• High-performance Bun runtime delivering faster startup and lower memory footprint compared to traditional Node.js

• Seamless Claude Code integration through .mcp.json configuration for simplified setup

• Multiple deployment methods including direct TypeScript execution, Bunx auto-install, or compiled standalone binaries

Uses .env files to manage environment variables for database connection configurations, supporting flexible deployment across different environments.

Leverages npm for package management, installation of dependencies, and running build and development scripts for the MCP server.

Utilizes TypeScript for type definitions and project structure, with the codebase organized into TypeScript modules for database management and type definitions.