Best of / Skills
Best Databases Skills
30 Skills in the databases category, ranked by GitHub stars — updated automatically as our nightly sync refreshes stats.
- 1412
analyzing-data
Queries the data warehouse with SQL and answers business questions about data. Use when answering anything that needs warehouse data - counts, metrics, trends, aggregations, joins across tables, data lookups, or ad-hoc SQL analysis (for example "who uses X", "how many Y", "show me Z", "find customer
- 2412
cosmos-dbt-fusion
Run a dbt Fusion project with Astronomer Cosmos. Use when running a dbt Fusion project with Astronomer Cosmos (Cosmos 1.11+, ExecutionMode.LOCAL on Snowflake/Databricks). Before implementing, verify dbt engine is Fusion (not Core), the warehouse is supported, and local execution is acceptable. Does
- 3359
ai-skills
24 cross-platform agent skills for Claude Code, Cursor, Codex & Gemini CLI — databases, messaging, research, TTS, DevOps, and Google Workspace
- 4151
page-prep
Prepare any webpage for clean interaction by detecting and removing disruptive overlays (cookie banners, GDPR consent, modals, popups, newsletter signups, paywalls, login walls). Uses a cached database of 300+ known CMPs (Consent-O-Matic + EasyList) combined with heuristic DOM scanning. Injects a se
- 5151
commerce-app-storage
Integrate App Builder Database Storage (@adobe/aio-lib-db) into an Adobe Commerce app and scaffold a runtime action that reads and writes documents. Use when the user wants persistent, queryable storage backing a Commerce app — either from a web action (HTTP-invokable) or from an event/webhook handl
- 668
claude-memory-mcp
Local-first SQLite memory and continuity journal for MCP clients.
- 765
auditing-warehouse-source-health
Audit the health of a PostHog project's data warehouse sources and syncs — find every broken or degraded source connection, sync schema, and webhook channel. Use when the user asks "why are my imports failing?", "what's broken with my sources?", "why is my warehouse data stale?", or wants a one-shot
- 856
pomodoro
Reference implementation of the System Skill Pattern for building Claude Skills that remember, learn, and improve over time. CLI + SKILL.md + Database demonstrated via a Pomodoro timer.
- 930
smg-claude-memory-mcp
Production-grade vector memory MCP server for Claude Code. Semantic search, per-project isolation, rules enforcement, team sharing via git.
- 1022
alloydb-postgres-access-management
Use these skills when you need to manage database users, inspect permissions and roles, and verify global configuration parameters related to security and access control.
- 1122
alloydb-postgres-admin
Use these skills when you need to provision new AlloyDB clusters and instances, monitor their creation status, and retrieve high-level configuration or health data for the environment.
- 1222
alloydb-postgres-replication
Use these skills when you need to monitor replication health, manage sync states between nodes, and ensure the high availability and data distribution of your AlloyDB cluster.
- 1322
alloydb-postgres-health
Use these skills when you need to optimize storage, identify index issues, analyze table statistics, or manage autovacuum and tablespace configurations to maintain peak database health.
- 1422
alloydb-postgres-data
Use these skills when you need to explore the database schema, identify objects like views and triggers, and execute custom SQL queries to interact with your data.
- 1522
alloydb-postgres-optimize
Use these skills when you need to discover and manage PostgreSQL extensions or fine-tune engine-level settings such as memory allocation and server configuration parameters.
- 167
setup-warehouse-bigquery
Set up BigQuery as a data warehouse for Confidence. Use when the user chose BigQuery for warehouse setup.
- 177
setup-warehouse-redshift
Set up Redshift as a data warehouse for Confidence. Use when the user chose Redshift for warehouse setup.
- 184
alloydb-omni-health
Use these skills when you need to audit database health, identify storage bloat, find broken indexes, and verify tablespace or maintenance configurations.
- 194
alloydb-omni-replication
Use these skills when you need to monitor the health of database replication, manage sync states between nodes, and audit publication tables for distributed setups.
- 204
alloydb-omni-performance
Use these skills when you need to analyze query performance, generate execution plans, check table/column statistics, and monitor overall database activity.
- 214
alloydb-omni-data
Use these skills when you need to explore the database structure, identify schema objects like views and triggers, and execute SQL queries to interact with your data.
- 220
migration-review
SQLite migration assessment for items with the needs-migration-review trait. Evaluates schema changes, table recreation patterns, data migration strategy, and Flyway migration correctness. Invoked via skillPointer when filling migration-assessment notes.
- 230
bigquery-data
Use these skills when you need to handle large-scale data exploration and dataset management. Use when users need to find data assets or run SQL at scale. Provides metadata discovery and query execution across the data warehouse.
- 240
setup-warehouse-databricks
Set up Databricks as a data warehouse for Confidence. Use when the user chose Databricks for warehouse setup.
- 250
cloud-sql-sqlserver-admin
Use these skills when you need to provision new Cloud SQL for SQL Server instances, create databases and users, clone existing environments, and monitor the progress of long-running operations.
- 260
bigquery-analytics
Use these skills when you need to handle advanced data intelligence and predictive tasks. Use when a user asks "why" data changed or needs future projections. Provides automated insight generation and time-series forecasting.
- 270
suggesting-data-imports
Use when the user asks about revenue, payments, subscriptions, billing, CRM deals, support tickets, ad spend, production database tables, or other data PostHog does not collect natively — or wants to join or correlate PostHog product events with that external business data. Also use when a query fai
- 280
bigquery-graph
Provides guidelines and best practices for querying and defining property graphs and semantic graphs in BigQuery using GQL (Graph Query Language). Use when creating property graphs or querying graph topologies in BigQuery.
- 290
connecting-to-data-source
Create and troubleshoot AWS Glue connections to JDBC databases (Oracle, SQL Server, PostgreSQL, MySQL, RDS), Redshift, Snowflake, and BigQuery. Gathers connection hints from user, discovers existing connections and RDS/Redshift candidates, registers credentials in Secrets Manager or IAM DB auth, con
- 300
clickstack-otel-collector
Use when a user wants to wire an OpenTelemetry collector into a Managed ClickStack service on ClickHouse Cloud, either by deploying a new local collector (Docker run or Docker Compose) or by configuring their own existing collector, then send rich synthetic telemetry and verify it is visible in Clic
FAQ
How is this ranked?
By GitHub stars by default. Once a skill has community reviews, its rating is shown alongside the star count on its detail page.
How often is this updated?
Star counts and READMEs refresh automatically every night via our GitHub sync.