Doris MCP Server

1. exec_query

Execute SQL query and return results.

2. get_table_schema

Get detailed table structure information.

3. get_db_table_list

Get list of all table names in specified database.

4. get_db_list

Get list of all database names.

5. get_table_comment

Get table comment information.

6. get_table_column_comments

Get comment information for all columns in table.

7. get_table_indexes

Get index information for specified table.

8. get_recent_audit_logs

Get audit log records for recent period.

9. get_catalog_list

Get list of all catalog names.

10. get_sql_explain

Get SQL execution plan with configurable content truncation and file export for LLM analysis.

11. get_sql_profile

Get SQL execution profile with content management and file export for LLM optimization workflows.

12. get_table_data_size

Get table data size information via FE HTTP API.

13. get_monitoring_metrics_info

Get Doris monitoring metrics definitions and descriptions.

14. get_monitoring_metrics_data

Get actual Doris monitoring metrics data from nodes with flexible BE discovery.

15. get_realtime_memory_stats

Get real-time memory statistics via BE Memory Tracker with auto/manual BE discovery.

16. get_historical_memory_stats

Get historical memory statistics via BE Bvar interface with flexible BE configuration.

17. analyze_data_quality

Comprehensive data quality analysis combining completeness and distribution analysis.

18. trace_column_lineage

End-to-end column lineage tracking through SQL analysis and dependency mapping.

19. monitor_data_freshness

Real-time data staleness monitoring with configurable freshness thresholds.

20. analyze_data_access_patterns

User behavior analysis and security anomaly detection with access pattern monitoring.

21. analyze_data_flow_dependencies

Data flow impact analysis and dependency mapping between tables and views.

22. analyze_slow_queries_topn

Performance bottleneck identification with top-N slow query analysis and patterns.

23. analyze_resource_growth_curves

Capacity planning with resource growth analysis and trend forecasting.

24. exec_adbc_query

High-performance SQL execution using ADBC (Arrow Flight SQL) protocol.

25. get_adbc_connection_info

ADBC connection diagnostics and status monitoring for Arrow Flight SQL.

{
  "mcpServers": {
    "doris-stdio": {
      "command": "doris-mcp-server",
      "args": ["--transport", "stdio"],
      "env": {
        "DORIS_HOST": "127.0.0.1",
        "DORIS_PORT": "9030",
        "DORIS_USER": "root",
        "DORIS_PASSWORD": "your_db_password"
      }
    },
    "doris-http": {
      "url": "http://127.0.0.1:3000/mcp"
    }
  }
}