@dudqls816/database-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MAX_ROWS | No | Maximum number of rows returned by the query tool. Default is 1000. | 1000 |
| DATABASE_URL | Yes | Connection string in the format mssql://user:password@host:1433/database. Special characters must be URL-encoded. TLS options can be set via query string (e.g., ?encrypt=false&trustServerCertificate=false). | |
| ALLOW_PROCEDURE | No | When set to the string 'true', registers procedure-related tools (list_procedures, describe_procedure, call_procedure). Any other value is treated as false. Default is false. | false |
Instructions
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.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_tablesA | 데이터베이스의 모든 테이블과 뷰를 스키마와 함께 나열합니다. |
| describe_tableA | 테이블의 컬럼, 자료형, NULL 허용 여부, 기본값, 기본키를 조회합니다. |
| queryA | SELECT 문 하나를 실행합니다. 여러 문장, 쓰기, EXEC 는 거부됩니다. 파라미터는 @이름 형태로 쓰고 params 로 값을 넘기세요. 파라미터는 값만 바인딩할 수 있어 테이블명이나 컬럼명에는 쓸 수 없습니다. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 3 tools
Each tool has a clear, distinct role: listing all tables/views, describing a specific table's schema, and executing a read-only SELECT query. There is no functional overlap.
The first two tools follow a verb_noun pattern (list_tables, describe_table), but 'query' deviates by being a single verb. Overall, the naming is readable and predictable.
With 3 tools, the set is at the lower end of the typical range but still well-scoped for a read-only database server. Each tool provides a necessary capability and none feels redundant.
For the intended read-only scope, the toolset covers schema discovery and data querying adequately. It lacks write operations and complex SQL, but these are deliberately excluded, so the surface is reasonably complete.