No. 012 Databases
SQL Optimization
Queries that scale instead of stall
- Version
- 1.0.0
- License
- MIT
- Triggers
- slow database query; adding an index…
7 skills
Databases skills for OpenCode
Skills for schema design, query tuning, and the operational details of Postgres, ClickHouse, DuckDB, and serverless database platforms.
Download Databases skills
Free, MIT licensed, and ready to install
No. 049 Databases
PostgreSQL Best Practices
Indexing, queries, and performance tuning
- Version
- 1.0.0
- License
- MIT
- Triggers
- optimizing a slow PostgreSQL query; choosing an index type…
No. 050 Databases
ClickHouse Patterns
Analytics database best practices
- Version
- 1.0.0
- License
- MIT
- Triggers
- setting up a ClickHouse table; creating a materialized view…
No. 051 Databases
DuckDB Analytics
In-process analytics database
- Version
- 1.0.0
- License
- MIT
- Triggers
- querying a CSV file with SQL; using DuckDB with pandas…
No. 112 Databases
Supabase Postgres
Serverless Postgres patterns for Supabase
- Version
- 1.0.0
- License
- MIT
- Triggers
- setting up row-level security in Supabase; creating real-time subscriptions…
No. 113 Databases
Neon Serverless Postgres
Branching, scaling, and serverless Postgres
- Version
- 1.0.0
- License
- MIT
- Triggers
- creating a Neon database branch; setting up autoscaling…
No. 157 Databases
Data Modeling
Schemas that scale with your product
- Version
- 1.0.0
- License
- MIT
- Triggers
- designing a database schema; database normalization…