Skip to main content

de en es ja ko ru zh

Doris MCP Server

Apache 2.0

2

Overview InspectNew Schema Related Servers Reviews Score

Need Help?View Source Code Report Issue

Server Configuration

Describes the environment variables required to run the server.

Name	Required	Description	Default
`DB_HOST`	Yes	Database hostname
`DB_PORT`	No	Database port	9030
`DB_USER`	Yes	Database username
`LOG_DIR`	No	Directory for log files	./logs
`LOG_LEVEL`	No	Log level (e.g., INFO, DEBUG, WARNING, ERROR)	INFO
`DB_DATABASE`	Yes	Default database name
`DB_PASSWORD`	Yes	Database password
`SERVER_HOST`	No	Host address the server listens on	0.0.0.0
`SERVER_PORT`	No	Port the server listens on	3000
`ALLOWED_ORIGINS`	No	CORS allowed origins (comma-separated, * allows all)
`CONSOLE_LOGGING`	No	Whether to output logs to the console	false
`MCP_ALLOW_CREDENTIALS`	No	Whether to allow CORS credentials	false
`ENABLE_SQL_SECURITY_CHECK`	No	Whether to enable security checks for SQL queries

Schema

Prompts

Interactive templates invoked by user choice

Name	Description
No prompts

Resources

Contextual data attached and managed by the client

Name	Description
No resources

Tools

Functions exposed to the LLM to take actions

Name	Description
exec_query	[Function Description]: Execute SQL query and return result command (executed by the client). [Parameter Content]: sql (string) [Required] - SQL statement to execute db_name (string) [Optional] - Target database name, defaults to the current database max_rows (integer) [Optional] - Maximum number of rows to return, default 100 timeout (integer) [Optional] - Query timeout in seconds, default 30
get_table_schema	[Function Description]: Get detailed structure information of the specified table (columns, types, comments, etc.). [Parameter Content]: table_name (string) [Required] - Name of the table to query db_name (string) [Optional] - Target database name, defaults to the current database
get_db_table_list	[Function Description]: Get a list of all table names in the specified database. [Parameter Content]: db_name (string) [Optional] - Target database name, defaults to the current database
get_db_list	[Function Description]: Get a list of all database names on the server. [Parameter Content]: random_string (string) [Required] - Unique identifier for the tool call
get_table_comment	[Function Description]: Get the comment information for the specified table. [Parameter Content]: table_name (string) [Required] - Name of the table to query db_name (string) [Optional] - Target database name, defaults to the current database
get_table_column_comments	[Function Description]: Get comment information for all columns in the specified table. [Parameter Content]: table_name (string) [Required] - Name of the table to query db_name (string) [Optional] - Target database name, defaults to the current database
get_table_indexes	[Function Description]: Get index information for the specified table. [Parameter Content]: table_name (string) [Required] - Name of the table to query db_name (string) [Optional] - Target database name, defaults to the current database
get_recent_audit_logs	[Function Description]: Get audit log records for a recent period. [Parameter Content]: days (integer) [Optional] - Number of recent days of logs to retrieve, default is 7 limit (integer) [Optional] - Maximum number of records to return, default is 100

ID: el1kbjxehg