get_table_schema_in_database

MCP tool from Mssqlclient MCP Server by aadversteeg

Gets the schema of a table from a specific database.

How to use it

Project documentation lists get_table_schema_in_database for the Mssqlclient MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.

Install Mssqlclient MCP Server

docker run -d --name mssql-mcp -e "MSSQL_CONNECTIONSTRING=Server=your_server;Database=your_db;User Id=your_user;Password=your_password;TrustServerCertificate=True;" mssqlclient-mcp-server:latest

FULL MSSQLCLIENT MCP SERVER LISTING

Other tools in Mssqlclient MCP Server (24)

execute_query

Executes a SQL query on the connected SQL Server database.

execute_query_in_database

Executes a SQL query in a specific database.

execute_stored_procedure

Executes a stored procedure with automatic parameter type conversion.

execute_stored_procedure_in_database

Executes a stored procedure in a specific database with automatic parameter type conversion.

get_command_timeout

Returns current timeout configuration settings.

get_session_results

Get results from a completed or running query/stored procedure session.

get_session_status

Check the status of a running query or stored procedure session.

get_stored_procedure_definition

Gets the SQL definition of a stored procedure.

get_stored_procedure_definition_in_database

Gets the SQL definition of a stored procedure from a specific database.

get_stored_procedure_parameters

Gets parameter information for a stored procedure in table or JSON Schema format.

get_table_schema

Gets the schema of a table from the connected SQL Server database.

list_databases

Lists all databases on the SQL Server instance.

list_sessions

List all query and stored procedure sessions.

list_stored_procedures

Lists all stored procedures in the current database with detailed information.

list_stored_procedures_in_database

Lists all stored procedures in a specific database.

list_tables

Lists all tables in the connected SQL Server database with schema and row count information.

list_tables_in_database

Lists all tables in a specific database.

server_capabilities

Returns detailed information about the capabilities and features of the connected SQL Server instance.

set_command_timeout

Updates the default command timeout for all new operations.

start_query

Start a SQL query in the background on the connected database. Returns a session ID to check progress. Best for long-running queries.

start_query_in_database

Start a SQL query in the background for a specific database. Returns a session ID to check progress. Best for long-running queries (server mode).

start_stored_procedure

Start a stored procedure execution in the background. Returns a session ID to check progress. Best for long-running procedures.

start_stored_procedure_in_database

Start a stored procedure execution in the background for a specific database. Returns a session ID to check progress. Best for long-running procedures (server mode).

stop_session

Stop a running query or stored procedure session.