mcp-dbs

by cuongtl1992
Verified

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MCP_MSSQL_PORTNoSQL Server port number1433
MCP_MSSQL_USERNoSQL Server username
MCP_MSSQL_SERVERNoSQL Server address
MCP_POSTGRES_SSLNoWhether to use SSL for PostgreSQL connectionfalse
MCP_MSSQL_ENCRYPTNoWhether to encrypt SQL Server connectiontrue
MCP_POSTGRES_HOSTNoPostgreSQL host address
MCP_POSTGRES_PORTNoPostgreSQL port number5432
MCP_POSTGRES_USERNoPostgreSQL username
MCP_MSSQL_DATABASENoSQL Server database name
MCP_MSSQL_PASSWORDNoSQL Server password
MCP_SQLITE_FILENAMENoPath to the SQLite database file
MCP_POSTGRES_DATABASENoPostgreSQL database name
MCP_POSTGRES_PASSWORDNoPostgreSQL password
MCP_SQLITE_CREATE_IF_NOT_EXISTSNoWhether to create the SQLite database if it doesn't exist
MCP_MSSQL_TRUST_SERVER_CERTIFICATENoWhether to trust the SQL Server certificatetrue

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools