Aurora Dsql
Aurora DSQL allows you to query your Amazon Redshift data directly from SQL using AWS Glue DataBrew for faster insights and analysis.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add aurora-dsql npx -- -y @trustedskills/aurora-dsql
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"aurora-dsql": {
"command": "npx",
"args": [
"-y",
"@trustedskills/aurora-dsql"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
The aurora-dsql skill allows AI agents to interact with Amazon Aurora databases using SQL queries. It facilitates data retrieval, modification, and analysis directly within the agent's workflow. This enables automated tasks like report generation, data validation, and database maintenance through an AI interface.
When to use it
- Automated Reporting: Generate daily or weekly reports by querying specific tables in your Aurora database.
- Data Validation: Verify data integrity by running SQL checks and alerting on anomalies detected within the database.
- Database Administration: Perform routine maintenance tasks like index optimization or table backups via SQL commands executed through the agent.
- Business Intelligence: Extract key metrics from your databases to inform decision-making processes.
Key capabilities
- SQL Query Execution: Executes standard SQL queries against Aurora databases.
- Data Retrieval: Retrieves data from tables based on specified criteria.
- Database Interaction: Allows for modification and analysis of database content.
Example prompts
- "Get me the total sales for last month from the 'orders' table."
- "Run a query to find all customers who haven’t placed an order in the last 90 days."
- “Update the ‘products’ table and set the price of item ID 123 to $19.99.”
Tips & gotchas
Ensure your AI agent has the necessary database credentials and permissions before using this skill. The accuracy of results depends on the correctness of SQL queries provided within prompts.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.