MCPVault

type

MCP tool from Mssql MCP by codegiveness

enum

How to use it

type is exposed by the Mssql MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the type tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install Mssql MCP

$npx -y @codegiveness/mssql-mcp --version
FULL MSSQL MCP LISTING

Other tools in Mssql MCP (17)

analyze_db_health

Summary health check: size, VLFs, fragmentation, stats staleness, blocking.

analyze_indexes

Missing-index analysis from sys.dmdbmissingindex DMVs (workload-wide or per-query).

database

string

execute_sql

Execute a T-SQL batch. SELECT in Restricted; DML/DDL in Unrestricted.

explain_query

Show the execution plan summary (or raw XML) without executing the query.

format

enum

get_object_details

Return columns, parameters, indexes, and triggers for a specific object.

get_top_queries

Top queries by CPU/duration/reads from sys.dmexecquerystats.

limit

int

list_databases

List all databases with an iscurrent flag (system DBs excluded).

list_objects

List tables/views/procedures/functions with schema, type, and limit filters (default 1000).

list_schemas

List schemas in the current or specified database.

name

string

order_by

enum

query

string

schema

string

sql

string