MCP Server Mssql

Install

Works with Claude Code, Codex, VS Code, Cursor, Windsurf, Claude Desktop. Read the repository before you give any tool access to your data.

npx agentmarket install connector/daedalus-mcp-server-mssql

About

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this server can do and what it asks for, from its tool list and install config. Checked Oct 25, 2026.

Tools

9 read · 8 write · 1 delete · 3 not yet classified

Secrets

None asked for

Install scripts

Not scanned yet

Runs as

Python package

Tools (21)

Read from the source code; the running server may differ. Descriptions are the server’s own words; hidden characters are shown as [U+…].

• build_connection_string

  Build a SQL Server connection string from components. Args: server: Server hostname or IP address database: Database name user: Username for SQL authentication password: Password for SQL authentication driver: ODBC driver name (default: ODBC Driver 18 for SQL Server) encrypt: Enable encryption (yes/no) trust_cert: Trust server certificate (yes/no) authentication: Authentication method Returns: Connection string. Example: >>> build_connection_string(server="localhost", database="TestDB") "SERVER=localhost;DATABASE=TestDB;DRIVER={ODBC Driver 18 for …

• bulk_copy

  Perform a bulk copy operation to load data into a table. Args: connection_id: The ID returned from connect_tool table_name: Target table name data: List of tuples or lists representing rows to insert column_mappings: Optional list of column mappings batch_size: Batch size for bulk copy (0 = all at once) keep_identity: Whether to keep identity values check_constraints: Whether to check constraints keep_nulls: Whether to keep NULL values fire_triggers: Whether to fire triggers Returns: Dictionary with bulk copy result. Example: >>> bulk_copy("abc123…

• call_procedure

  Call a stored procedure. Args: connection_id: The ID returned from connect_tool procedure_name: Name of the stored procedure params: Optional list of parameters Returns: Dictionary with procedure results. Example: >>> call_procedure("abc123", "sp_GetUsers", [1]) {"result": [{"id": 1, "name": "John"}]}

• close_connection

  Close an existing database connection. Args: connection_id: The ID returned from connect_tool Returns: Dictionary with status confirmation. Example: >>> close_connection("abc123") {"status": "closed", "connection_id": "abc123"}

• commit

  Commit the current transaction. Args: connection_id: The ID returned from connect_tool Returns: Dictionary with status confirmation. Example: >>> commit("abc123") {"status": "committed", "connection_id": "abc123"}

• connect_tool

  Connect to Microsoft SQL Server using the provided connection string. Args: connection_string: SQL Server connection string in semicolon-delimited key=value format (e.g., "SERVER=tcp:localhost;DATABASE=mydb;Authentication=ActiveDirectoryInteractive;Encrypt=yes;") Returns: Dictionary containing connection_id and server info. The connection_id should be used for subsequent operations. Example: >>> connect_tool("SERVER=localhost;DATABASE=TestDB;UID=sa;PWD=password;") {"connection_id": "abc123", "server_name": "localhost", "database": "TestDB"}

• execute_query

  Execute a SQL query and return results. Args: connection_id: The ID returned from connect_tool sql: SQL statement to execute params: Optional list of parameters for parameterized query Returns: List of row dictionaries. Example: >>> execute_query("abc123", "SELECT * FROM users WHERE active = 1") [{"id": 1, "name": "John", "active": true}, {"id": 2, "name": "Jane", "active": true}]

• execute_scalar

  Execute a SQL query and return a single value. Args: connection_id: The ID returned from connect_tool sql: SQL statement that returns a single value Returns: The single value from the query result. Example: >>> execute_scalar("abc123", "SELECT COUNT(*) FROM users") 42

• fetch_results

  Fetch results from an existing cursor. Args: connection_id: The ID returned from connect_tool cursor_id: The cursor ID from execute_query mode: Fetch mode - "one", "many", or "all" (default: "all") size: Number of rows for "many" mode Returns: List of row dictionaries. Example: >>> fetch_results("abc123", "cursor123", mode="many", size=10) [{"id": 1, "name": "John"}, {"id": 2, "name": "Jane"}]

• get_columns

  Get list of columns for a table. Args: connection_id: The ID returned from connect_tool table_name: Name of the table catalog: Optional catalog filter schema: Optional schema filter Returns: List of column information dictionaries. Example: >>> get_columns("abc123", "users") [{"column_name": "id", "data_type": "int", "is_nullable": false}, {"column_name": "name", "data_type": "varchar", "is_nullable": true}]

• get_connection_info

  Get information about a connection. Args: connection_id: The ID returned from connect_tool Returns: Dictionary with connection information. Example: >>> get_connection_info("abc123") {"server_name": "localhost", "database": "TestDB", "driver_name": "ODBC Driver 18"}

• get_foreign_keys

  Get foreign keys for a table. Args: connection_id: The ID returned from connect_tool table_name: Name of the table catalog: Optional catalog filter schema: Optional schema filter Returns: List of foreign key information dictionaries. Example: >>> get_foreign_keys("abc123", "orders") [{"foreign_key_name": "FK_orders_users", "column_name": "user_id", "referenced_table": "users", "referenced_column": "id"}]

• get_primary_keys

  Get primary keys for a table. Args: connection_id: The ID returned from connect_tool table_name: Name of the table catalog: Optional catalog filter schema: Optional schema filter Returns: List of primary key information dictionaries. Example: >>> get_primary_keys("abc123", "users") [{"column_name": "id", "key_name": "PK_users"}]

• get_procedures

  Get list of stored procedures from the database. Args: connection_id: The ID returned from connect_tool catalog: Optional catalog filter schema: Optional schema filter Returns: List of procedure information dictionaries. Example: >>> get_procedures("abc123") [{"procedure_name": "sp_GetUsers", "procedure_schema": "dbo"}]

• get_tables

  Get list of tables from the database. Args: connection_id: The ID returned from connect_tool catalog: Optional catalog filter schema: Optional schema filter Returns: List of table information dictionaries. Example: >>> get_tables("abc123") [{"table_name": "users", "table_type": "TABLE"}, {"table_name": "orders", "table_type": "TABLE"}]

Signals

Stars

0

Forks

0

Open issues

0

Weekly downloads

50

Last commit

Apr 21, 2026 (6 months ago)

Last release

Apr 3, 2026 (6 months ago)

Last package publish

Apr 3, 2026 (6 months ago)

From GitHub (fetched Oct 24, 2026) and the package registry.

Details

Registry name

io.github.daedalus/mcp-server-mssql

Version

0.1.0

Auth

No auth

Packages

pypi mcp-server-mssql

License

MIT

Repository

github.com/daedalus/mcp-server-mssql

First seen

Oct 24, 2026

Last checked

Oct 25, 2026

Source

Official MCP Registrygithub-graphql