GitHub
database
Database optimization, query tuning, migrations, and administration. Use for database performance issues, schema design, or operational tasks.
☆ 69View skill
devops data engineering AI Skills
Discover devops data engineering skills, compare source repositories and read the instructions for each workflow.
Categories: devops data engineering
devops data engineering Clear filters
Browse skills
GitHub
data-engineer
Build ETL pipelines, data warehouses, and streaming architectures. Use for data pipeline design or analytics infrastructure.
☆ 69View skill
GitHub
sql
Write SQL queries, optimize execution plans, and design schemas. Use for query optimization, complex joins, or database design.
☆ 69View skill
GitHub
data-science
Data analysis, SQL queries, BigQuery operations, and data insights. Use for data analysis tasks and queries.
☆ 69View skill
GitHub
geoparquet
Convert spatial data (GeoJSON, Shapefile, etc.) to optimized GeoParquet using the gpio CLI. Analyzes files, recommends settings, and publishes to cloud storage.
☆ 68View skill
GitHub
prisma
Prisma ORM patterns including Prisma Client usage, queries, mutations, relations, transactions, and schema management. Use when working with Prisma database operations or schema definitions.
☆ 65View skill
GitHub
database-schema-designer
SQL and NoSQL schema design with normalization, indexing, and migration patterns. Use when designing database schemas, creating tables, optimizing slow queries, or planning database migrations.
☆ 61View skill
GitHub
golden-dataset-validation
Use when validating golden dataset quality. Runs schema checks, duplicate detection, and coverage analysis to ensure dataset integrity for AI evaluation.
☆ 61View skill
GitHub
golden-dataset-management
Use when backing up, restoring, or validating golden datasets. Prevents data loss and ensures test data integrity for AI/ML evaluation systems.
☆ 61View skill
GitHub
zero-downtime-migration
Safe database schema changes without downtime using expand-contract pattern and online schema changes. Use when deploying schema changes to production without service interruption.
☆ 61View skill
GitHub
tanstack-query-advanced
Advanced TanStack Query v5 patterns for infinite queries, optimistic updates, prefetching, gcTime, and queryOptions. Use when building data fetching, caching, or optimistic updates.
☆ 61View skill
GitHub
symfonydoctrine-batch-processing
Use when symfony doctrine batch processing
☆ 61View skill
GitHub
query-expert
Master SQL and database queries across multiple systems. Generate optimized queries, analyze performance, design indexes, and troubleshoot slow queries for PostgreSQL, MySQL, MongoDB, and more.
☆ 61View skill
GitHub
ci-cd-fix
Fix CI/CD pipeline issues with environment analysis, Docker optimization, and deployment validation. Use when addressing build, test, or deployment failures in CI/CD. Focus on environment analysis, Docker optim...
☆ 57View skill
GitHub
managing-bd-tasks
Use for advanced bd operations - splitting tasks mid-flight, merging duplicates, changing dependencies, archiving epics, querying metrics, cross-epic dependencies
☆ 56View skill
GitHub
optimizing-query-by-id
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...
☆ 56View skill
GitHub
migrating-sql-to-dbt
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", "trans...
☆ 56View skill
GitHub
documenting-dbt-models
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", "descript...
☆ 56View skill
GitHub
testing-dbt-models
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"...
☆ 56View skill
GitHub
finding-expensive-queries
Finds and ranks expensive Snowflake queries by cost, time, or data scanned. Use when: (1) User asks to find slow, expensive, or problematic queries (2) Task mentions "query history", "top queries", "most expens...
☆ 56View skill
GitHub
optimizing-query-text
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 "sl...
☆ 56View skill
GitHub
debugging-dbt-errors
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,...
☆ 56View skill
GitHub
creating-dbt-models
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", "a...
☆ 56View skill
GitHub
refactoring-dbt-models
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...
☆ 56View skill
The default order uses GitHub repository stars from our indexed data. Stars belong to the source repository and may be shared by multiple skills. They indicate repository interest, not skill installs or an independent quality score.