Database
Database management and queries
creating-dbt-models
by AltimateAI
Creates dbt models following project conventions. Use when working with dbt models for: (1) Creating new models (any layer - discovers project's naming conventions first) (2) Task mentions "create", "build", "add", "write", "new", or "implement" with model, table, or SQL (3) Modifying existing model logic, columns, joins, or transformations (4) Implementing a model from schema.yml specs or expected output requirements Discovers project conventions before writing. Runs dbt build (not just compile) to verify.
refactoring-dbt-models
by AltimateAI
Safely refactors dbt models with downstream impact analysis. Use when restructuring dbt models for: (1) Task mentions "refactor", "restructure", "extract", "split", "break into", or "reorganize" (2) Extracting CTEs to intermediate models or creating macros (3) Modifying model logic that has downstream consumers (4) Renaming columns, changing types, or reorganizing model dependencies Analyzes all downstream dependencies BEFORE making changes.
documenting-dbt-models
by AltimateAI
Documents dbt models and columns in schema.yml. Use when working with dbt documentation for: (1) Adding model descriptions or column definitions to schema.yml (2) Task mentions "document", "describe", "description", "dbt docs", or "schema.yml" (3) Explaining business context, grain, meaning of data, or business rules (4) Preparing dbt docs generate or improving model discoverability Matches existing project documentation style and conventions before writing.
testing-dbt-models
by AltimateAI
Adds schema tests and data quality validation to dbt models. Use when working with dbt tests for: (1) Adding or modifying tests in schema.yml files (2) Task mentions "test", "validate", "data quality", "unique", "not_null", or "accepted_values" (3) Ensuring data integrity - primary keys, foreign keys, relationships (4) Debugging test failures or understanding why dbt test failed Matches existing project test patterns and YAML style before adding new tests.
optimizing-query-by-id
by AltimateAI
Optimizes Snowflake query performance using query ID from history. Use when optimizing Snowflake queries for: (1) User provides a Snowflake query_id (UUID format) to analyze or optimize (2) Task mentions "slow query", "optimize", "query history", or "query profile" with a query ID (3) Analyzing query performance metrics - bytes scanned, spillage, partition pruning (4) User references a previously run query that needs optimization Fetches query profile, identifies bottlenecks, returns optimized SQL with expected improvements.
debugging-dbt-errors
by AltimateAI
Debugs and fixes dbt errors systematically. Use when working with dbt errors for: (1) Task mentions "fix", "error", "broken", "failing", "debug", "wrong", or "not working" (2) Compilation Error, Database Error, or test failures occur (3) Model produces incorrect output or unexpected results (4) Need to troubleshoot why a dbt command failed Reads full error, checks upstream first, runs dbt build (not just compile) to verify fix.
optimizing-query-text
by AltimateAI
Optimizes Snowflake SQL query performance from provided query text. Use when optimizing Snowflake SQL for: (1) User provides or pastes a SQL query and asks to optimize, tune, or improve it (2) Task mentions "slow query", "make faster", "improve performance", "optimize SQL", or "query tuning" (3) Reviewing SQL for performance anti-patterns (function on filter column, implicit joins, etc.) (4) User asks why a query is slow or how to speed it up
migrating-sql-to-dbt
by AltimateAI
Converts legacy SQL to modular dbt models. Use when migrating SQL to dbt for: (1) Converting stored procedures, views, or raw SQL files to dbt models (2) Task mentions "migrate", "convert", "legacy SQL", "transform to dbt", or "modernize" (3) Breaking monolithic queries into modular layers (discovers project conventions first) (4) Porting existing data pipelines or ETL to dbt patterns Checks for existing models/sources, builds and validates layer by layer.
gdcli
by w-winter
Google Drive CLI for listing, searching, uploading, downloading, and sharing files and folders.
backend-development
by aAAaqwq
后端服务开发专家（通才）。精通多种后端技术栈，能够根据需求选择最合适的技术方案。 当用户需要开发API、数据库设计、微服务架构或后端业务逻辑时使用此技能。 根据用户需求的技术栈，自动切换到对应语言的专家模式： - Python → 查看 python/SKILL.md - Node.js → 查看 nodejs/SKILL.md - Go → 查看 go/SKILL.md - Java → 查看 java/SKILL.md
coda-automation
by aAAaqwq
"Automate Coda tasks via Rube MCP (Composio): manage docs, pages, tables, rows, formulas, permissions, and publishing. Always search tools first for current schemas."
writing-database-queries
by bitwarden
Bitwarden database architecture, migrations, and dual-ORM strategy. Use when working with .sql files, stored procedures, EF migrations, or database schema changes.
convex-helpers-guide
by get-convex
Discover and use convex-helpers utilities for relationships, filtering, sessions, custom functions, and more. Use when you need pre-built Convex patterns.
migration-helper
by get-convex
Plan and execute Convex schema migrations safely, including adding fields, creating tables, and data transformations. Use when schema changes affect existing data.
geo-optimization
by fabricioctelles
This skill should be used when the user wants to improve content visibility in AI-generated responses (ChatGPT, Perplexity, Google AI Overview, Grok, Claude, Gemini), needs a GEO/AEO strategy, wants to measure citation rate, align terminology for LLMs, audit existing pages for AI discoverability, or create optimized pages such as roundups and FAQs.
meta-inspector
by Jamie-BitFlight
Extract specific data points from agent output transcripts, kaizen analysis reports, and JSONL session files without loading raw data into orchestrator context. Use when needing tool timings, query counts, error summaries, or any structured facts from large output files. Prevents context pollution from raw transcript reads.
database
by whawkinsiv
"Use this skill when the user needs to choose a database, design a schema, set up Supabase or another database, write queries, handle migrations, or fix data-related issues. Covers database selection, schema design, Row Level Security, migrations, and common patterns for SaaS apps built by non-technical founders."
database-design
by skillcreatorai
Database schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases. Use for designing schemas, writing migrations, or optimizing queries.
azure-cosmosdb
by alinaqi
Azure Cosmos DB partition keys, consistency levels, change feed, SDK patterns
cloudflare-d1
by alinaqi
Cloudflare D1 SQLite database with Workers, Drizzle ORM, migrations
supabase-python
by alinaqi
FastAPI with Supabase and SQLAlchemy/SQLModel
supabase-nextjs
by alinaqi
Next.js with Supabase and Drizzle ORM
shopify-apps
by alinaqi
Shopify app development - Remix, Admin API, checkout extensions
supabase-node
by alinaqi
Express/Hono with Supabase and Drizzle ORM