MCP Tool Categories

Query + Gateway Tools

• execute_sql
• fetch_rows
• insert_row
• update_row
• delete_row
• run_pipeline

Schema + Management Tools

• list_tables, list_columns
• create_table, drop_table
• create_index, drop_index
• list_indexes, list_foreign_keys

Client + Auth Administration

• list_athena_clients_admin
• create_athena_client, update_athena_client
• list_api_keys, create_api_key, update_api_key
• list_api_key_rights, rights grant/update/delete operations

Backup + Cluster Operations

• backup job and schedule endpoints
• cluster health checks
• metrics and logs retrieval
• provisioning and instance lifecycle operations

Recommended Guardrails

• Separate read-only and write-capable tool profiles.
• Scope keys to explicit client names.
• Log every privileged operation and review drilldown routes regularly.