Schema | sqlserver

sqlserver

Describes the environment variables required to run the server.

Name	Required	Description	Default
`SQL_SERVER_HOST`	No	The SQL Server host	localhost
`SQL_SERVER_PORT`	No	The SQL Server port	1433
`SQL_SERVER_USER`	No	The database user	sa
`SQL_SERVER_ENCRYPT`	No	Whether to encrypt the connection	false
`SQL_SERVER_DATABASE`	No	The database name	SampleDB
`SQL_SERVER_PASSWORD`	No	The database password	YourStrong@Passw0rd

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Features and capabilities supported by this server

Protocol revision2025-11-25

Capability	Details
`tools`	{}

Functions exposed to the LLM to take actions

Name	Description
execute_queryA	Execute a SQL query and return results. Use for SELECT queries to retrieve data.
get_table_schemaA	Get the schema/structure of a table including column names, types, and constraints
list_tablesA	List all tables in the database
get_table_statsB	Get statistics about a table including row count and column information
execute_insertA	Insert data into a table. Returns the inserted row ID if available.
execute_updateB	Update data in a table. Returns the number of affected rows.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/AshwathDAzur/mcp-localdata-ai-bridge'

If you have feedback or need assistance with the MCP directory API, please join our Discord server