Manage AWS Athena databases and tables with read operations. This tool provides operations for retrieving information about databases and tables in Athena data catalogs. These are read-only operations that do not modify any resources. ## Requirements - Appropriate AWS permissions for Athena dat...
Accepts freeform code/query input (expression); Single-target operation
Part of the Amazon Data Processing MCP Server MCP server. Enforce policies on this tool with Intercept, the open-source MCP proxy.
AI agents use manage_aws_athena_databases_and_tables to create or modify resources in Amazon Data Processing MCP Server. Write operations carry medium risk because an autonomous agent could trigger bulk unintended modifications. Rate limits prevent a single agent session from making hundreds of changes in rapid succession. Argument validation ensures the agent passes expected values.
Without a policy, an AI agent could call manage_aws_athena_databases_and_tables repeatedly, creating or modifying resources faster than any human could review. Intercept's rate limiting ensures write operations happen at a controlled pace, and argument validation catches malformed or unexpected inputs before they reach Amazon Data Processing MCP Server.
Write tools can modify data. A rate limit prevents runaway bulk operations from AI agents.
tools:
manage_aws_athena_databases_and_tables:
rules:
- action: allow
rate_limit:
max: 30
window: 60See the full Amazon Data Processing MCP Server policy for all 36 tools.
Agents calling write-class tools like manage_aws_athena_databases_and_tables have been implicated in these attack patterns. Read the full case and prevention policy for each:
Other tools in the Write risk category across the catalogue. The same policy patterns (rate-limit, validate) apply to each.
Manage AWS Athena databases and tables with read operations. This tool provides operations for retrieving information about databases and tables in Athena data catalogs. These are read-only operations that do not modify any resources. ## Requirements - Appropriate AWS permissions for Athena database and table operations ## Operations - **get-database**: Get information about a single database - **get-table-metadata**: Get metadata for a specific table - **list-databases**: List all databases in a data catalog - **list-table-metadata**: List metadata for all tables in a database ## Usage Tips - Use list-databases to find available databases in a data catalog - Use list-table-metadata to find available tables in a database - The expression parameter for list-table-metadata supports filtering tables by name pattern ## Example ``` # List all databases in a catalog {'operation': 'list-databases', 'catalog_name': 'AwsDataCatalog', 'max_results': 10} # Get metadata for a specific table { 'operation': 'get-table-metadata', 'catalog_name': 'AwsDataCatalog', 'database_name': 'my_database', 'table_name': 'my_table', } ``` Args: ctx: MCP context operation: Operation to perform catalog_name: Name of the data catalog database_name: Name of the database table_name: Name of the table expression: Expression to filter tables max_results: Maximum number of results to return next_token: Pagination token work_group: The name of the workgroup Returns: Union of response types specific to the operation performed. It is categorised as a Write tool in the Amazon Data Processing MCP Server MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.
Add a rule in your Intercept YAML policy under the tools section for manage_aws_athena_databases_and_tables. You can allow, deny, rate-limit, or validate arguments. Then run Intercept as a proxy in front of the Amazon Data Processing MCP Server MCP server.
manage_aws_athena_databases_and_tables is a Write tool with medium risk. Write tools should be rate-limited to prevent accidental bulk modifications.
Yes. Add a rate_limit block to the manage_aws_athena_databases_and_tables rule in your Intercept policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.
Set action: deny in the Intercept policy for manage_aws_athena_databases_and_tables. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.
manage_aws_athena_databases_and_tables is provided by the Amazon Data Processing MCP Server MCP server (awslabs.aws-dataprocessing-mcp-server). Intercept sits as a proxy in front of this server to enforce policies before tool calls reach the server.
Deterministic policy on every MCP tool call. Per-identity grants. Full audit log.