Skip to content

opensite-ai/opensite-skills / aws-database

aws-database

Verified

Routes any task involving AWS databases — choosing, comparing, recommending, getting started with, or operating a database — to the correct service-specific skill. Supersedes general training-data knowledge with post-training service updates, corrected limitations, and decision procedures for relational (Aurora, DSQL, RDS), key-value (DynamoDB), wide-column (Keyspaces), document (DocumentDB), graph (Neptune), time-series (Timestream), and in-memory/caching (ElastiCache, MemoryDB) workloads. Activates when a user describes building an application on AWS that will store, retrieve, or manage data, even if they do not mention 'database' explicitly.

FileKindSize
.aws-skill-metadataother18 B
SKILL.mdskill md7.8 KB
assets/aurora-dsql.mdmarkdown1.4 KB
assets/aurora-mysql.mdmarkdown1.9 KB
assets/aurora-postgresql.mdmarkdown2.5 KB
assets/documentdb.mdmarkdown1.4 KB
assets/dynamodb.mdmarkdown2.9 KB
assets/elasticache.mdmarkdown3.4 KB
assets/keyspaces.mdmarkdown2.0 KB
assets/memorydb.mdmarkdown1.7 KB
assets/neptune.mdmarkdown2.1 KB
assets/odb-aws.mdmarkdown1.9 KB
assets/rds-db2.mdmarkdown1.1 KB
assets/rds-mariadb.mdmarkdown1.5 KB
assets/rds-mysql.mdmarkdown1.2 KB
assets/rds-oracle.mdmarkdown1.5 KB
assets/rds-postgresql.mdmarkdown1.4 KB
assets/rds-sqlserver.mdmarkdown1.3 KB
assets/timestream.mdmarkdown1.8 KB
references/handoff.mdmarkdown4.1 KB
references/report-issue.mdmarkdown3.9 KB
references/select.mdmarkdown19.5 KB

assets/aurora-postgresql.md

View on GitHub
# Aurora PostgreSQL

- **Docs**: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.AuroraPostgreSQL.html
- **Docs (llms.txt)**: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/llms.txt
- **Data model**: Relational (full PostgreSQL)
- **Query language**: PostgreSQL SQL (full dialect + extensions)
- **Compatibility**: Full PostgreSQL (all extensions, stored procedures, triggers, FDWs)
- **Serverless**: Yes
- **Serverless type**: Capacity — you create and manage a cluster, while compute scales automatically within the supported capacity range (currently up to 256 ACUs on supported engine and platform versions). Patching, upgrades, and maintenance remain a shared responsibility, consistent with standard Aurora PostgreSQL
- **Scale to zero**: Conditional — requires an engine version that supports auto-pause and a minimum capacity of 0 ACUs; otherwise the minimum is 0.5 ACU. Enabled features and settings can require a higher effective floor or prevent auto-pause
- **VPC required**: Yes (unless Express Configuration — no VPC, PostgreSQL only, limited regions)
- **Multi-region**: Global Database for disaster recovery (<1s replication, single write region)
- **Free Tier**: new-account AWS Free Tier — $100 in credits at sign-up plus up to $100 more ($200 total), usable across eligible services including Aurora for up to 12 months. Free plan gives Aurora PostgreSQL serverless up to 4 ACUs and 1 GiB storage per cluster; upgrade to Paid for up to 256 ACUs / 256 TiB (per aws.amazon.com/rds/aurora/pricing)
- **Min cost**: ~$0 with auto-pause (storage only); ~$45/month always-on at 0.5 ACU (compute only; storage billed separately)
- **Time to first query**: ~90-120 seconds (Express Configuration) or 10-15 min (standard VPC setup)
- **Key features**: Express Configuration, I/O-Optimized, Managed Upgrades with Blue/Green Deployments, AWS Organizations for upgrade rollout policy, PostgreSQL extensions including pgvector, dynamic data masking (pg_columnmask), PostGIS, Zero ETL integrations to Redshift and Opensearch, up to 5x write and 3x read throughput vs RDS, faster failover (<30s vs 60-120s for RDS Multi-AZ)
- **Limitations**: Single write region, slightly higher cost than RDS for equivalent instance size, proprietary storage layer (not portable to community PostgreSQL without application-level export)
- **Best for**: Workloads requiring full PostgreSQL, pgvector/AI embeddings, migrations from PostgreSQL, refactors from Oracle/SQL Server
- **Not for**: Users who just need simple SQL without PG-specific features (DSQL is simpler)
writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deploymentStars: 322kUpdated Claude CodeCodexVerifiedInstall
xlsxanthropics/skillsUse this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
shipping-and-launchaddyosmani/agent-skillsPrepares production launches. Use when preparing to deploy to production, or when asking what needs to be in place before shipping. Use when you need a pre-launch checklist, when setting up monitoring, when planning a staged rollout, or when you need a rollback strategy.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
childhoodthedotmack/claude-memBabysit a shipped release after merge, publication, or deployment. Verify published packages, production behavior, installed plugins, and late CI or user reports until the observation window is clean; use babysit for PR readiness before release.Stars: 118kUpdated Claude CodeCodexVerifiedInstall