Database

Database management and queries

Showing 2089-2112 of 3628 skills
Snowflake-Labs

cortex-classify-notebook

by Snowflake-Labs

Deploy the Cortex CLASSIFY_TEXT tutorial notebook to the user's Snowflake account and provide a link to open it in Snowsight. Use when user wants to learn text classification through a Jupyter notebook experience.

Code Gen 5 3mo ago
Snowflake-Labs

dynamic-tables-tutorial

by Snowflake-Labs

Interactive tutorial that teaches Snowflake Dynamic Tables hands-on. The agent guides users step-by-step through building data pipelines with automatic refresh, incremental processing, and CDC patterns. Use when the user wants to learn dynamic tables, build a DT pipeline, or understand DT vs streams/tasks/materialized views.

Code Gen 5 3mo ago
ozten

webdev-filter-query-builder

by ozten

Domain-specific filter query building with AST representation, operator handling, query serialization, and field-type-specific inputs. Use when building advanced filter UIs for observability tools, data analytics, search interfaces, or any system requiring structured query construction with boolean logic, comparison operators, and URL/string serialization.

Processing 5 4mo ago
mOdrA40

react-tanstack-senior

by mOdrA40

Expertise senior/lead React developer 20 tahun dengan TanStack ecosystem (Query, Router, Table, Form, Start). Gunakan skill ini ketika: (1) Membuat aplikasi React dengan TanStack libraries, (2) Review/refactor kode React untuk clean code, (3) Debugging React/TanStack issues, (4) Setup project structure yang maintainable, (5) Optimasi performa React apps, (6) Memilih library yang tepat untuk use case tertentu, (7) Mencegah common bugs dan memory leaks, (8) Implementasi best practices KISS dan less is more. Trigger keywords: React, TanStack, React Query, TanStack Router, TanStack Table, TanStack Form, TanStack Start, Vinxi, clean code, refactor, performance, debugging.

Database 5 5mo ago
anivar

zod

by anivar

Zod v4 best practices, patterns, and API guidance for schema validation, parsing, error handling, and type inference in TypeScript applications. Covers safeParse, object composition, refinements, transforms, codecs, branded types, and v3→v4 migration. Baseline: zod ^4.0.0. Triggers on: zod imports, z.object, z.string, z.infer, safeParse, mentions of "zod", "schema validation", "zod v4", or "z.enum".

Processing 10 3mo ago
YuniorGlez

programmatic-seo-pro

by YuniorGlez

Senior Programmatic SEO Architect & Data Engineer for 2026. Specialized in large-scale page generation using Next.js 16, dynamic metadata orchestration, and database-to-page automation. Expert in scaling content across thousands of long-tail segments while maintaining high E-E-A-T standards and optimizing for AI-driven Search Generative Experiences (SGE).

Processing 11 4mo ago
dtsong

client-delivery

by dtsong

"Use this skill when managing a consulting data cleaning engagement. Covers engagement setup, schema profiling, security tier selection, project scaffolding, deliverable generation, and client handoff. Common phrases: \"set up a cleaning project\", \"profile this schema\", \"data cleaning engagement\", \"generate deliverables\", \"client handoff\". Do NOT use for writing dbt models (use dbt-transforms), DuckDB queries (use duckdb), or pipeline orchestration (use data-pipelines)."

Processing 11 3mo ago
FortiumPartners

Rails Framework Skill - Quick Reference

by FortiumPartners

Quick Reference Complete - See REFERENCE.md for comprehensive details and advanced patterns

Code Gen 11 7mo ago
FortiumPartners

.NET Framework Skill - Quick Reference

by FortiumPartners

Quick Reference Complete - See REFERENCE.md for comprehensive details and advanced patterns

Auth 11 7mo ago
yanko-belov

n-plus-one-prevention

by yanko-belov

Use when fetching related data in loops. Use when seeing multiple queries for one request. Use when database is slow on list endpoints.

Caching 11 4mo ago
gmickel

convex

by gmickel

Convex backend development patterns, validators, indexes, actions, queries, mutations, file storage, scheduling, React hooks, and components. Use when writing Convex code, debugging Convex issues, or planning Convex architecture.

Auth 11 5mo ago
dtsong

data-testing

by dtsong

"Use this skill when designing testing strategies for data pipelines, writing SQL assertions, validating pipeline output, or packaging tests as client deliverables. Covers dbt test patterns, pipeline validation, SQL assertion libraries, test coverage targets, and test-as-deliverable packaging. Common phrases: \"data testing strategy\", \"pipeline validation\", \"SQL assertions\", \"test coverage\", \"test as deliverable\", \"data quality tests\". Do NOT use for writing dbt models (use dbt-transforms), DuckDB analytical queries (use duckdb), or pipeline scheduling (use data-pipelines)."

Processing 11 3mo ago
yanko-belov

dependency-inversion-principle

by yanko-belov

Use when a class creates its own dependencies. Use when instantiating concrete implementations inside a class. Use when told to avoid dependency injection for simplicity.

Code Gen 11 4mo ago
dtsong

data-integration

by dtsong

"Use this skill when designing data integrations or connecting systems. Covers iPaaS platforms (Workato, MuleSoft, Boomi), dlt pipelines, API patterns, CDC, webhooks, and Reverse ETL. Common phrases: \"connect these systems\", \"build a dlt pipeline\", \"event-driven architecture\", \"change data capture\". Do NOT use for stream processing frameworks (use event-streaming) or pipeline scheduling (use data-pipelines)."

API Dev 11 3mo ago
FortiumPartners

Phoenix Framework Skill - Quick Reference

by FortiumPartners

For More Details: See REFERENCE.md for comprehensive guides, advanced patterns, and production optimization strategies.

Database 11 7mo ago
YuniorGlez

auth-expert

by YuniorGlez

"Senior expert in Auth.js v5 (NextAuth), Edge-First authentication and security. Optimized for Next.js 16.1.1 and React 19.2."

Auth 11 4mo ago
FortiumPartners

Smoke Test Database Skill

by FortiumPartners

Load: skills/smoke-test-database/REFERENCE.md (~15KB)

Database 11 6mo ago
dtsong

duckdb

by dtsong

"Use this skill when working with DuckDB for local data analysis, file ingestion, or data exploration. Covers reading CSV/Excel/Parquet/JSON files into DuckDB, SQL analytics on local data, data profiling, cleaning transformations, and export to various formats. Common phrases: \"analyze this CSV\", \"DuckDB query\", \"local data analysis\", \"read Excel in SQL\", \"profile this data\". Do NOT use for dbt model building (use dbt-transforms with DuckDB adapter) or cloud warehouse administration."

Processing 11 3mo ago
dtsong

dbt-transforms

by dtsong

"Use this skill when building or reviewing dbt models, tests, or project structure. Triggers on analytics engineering tasks including staging/marts layers, materializations, incremental strategies, Jinja macros, sources, warehouse configuration, DuckDB adapter, data cleaning, and deduplication patterns. Common phrases: \"dbt model\", \"write a dbt test\", \"incremental strategy\", \"semantic layer\", \"dbt DuckDB\", \"cleaning patterns\". Do NOT use for Python DataFrame code (use python-data-engineering), pipeline scheduling (use data-pipelines), or standalone DuckDB queries without dbt (use duckdb)."

CI/CD 11 3mo ago
YuniorGlez

postgres-tuning

by YuniorGlez

"Senior Database Optimizer for PostgreSQL 17/18+, specialized in Asynchronous I/O (AIO), Query Plan Forensic, and Vector Index optimization."

Database 11 4mo ago
JWCodeWrote

dialectical-reasoning(唯物辩证法)

by JWCodeWrote

A cognitive operating system based on Dialectical Materialism (Materialism, Universal Connection, Eternal Development, Unity of Opposites) to force objective, non-linear analysis of complex engineering and logic problems.

Code Review 3 4mo ago
peopleforrester

backend-patterns

by peopleforrester

Common backend development patterns for APIs, databases, caching, and service architecture. Language-agnostic principles with examples in Python, TypeScript, and Go.

API Dev 3 4mo ago
Lehsqa

robyn-config-backend-best-practices

by Lehsqa

Robyn backend scaffolding and architecture guidance for projects using robyn-config. Use when creating or evolving Robyn services, choosing DDD vs MVC, choosing SQLAlchemy vs Tortoise, adding new entities/routes/repositories with robyn-config add, auditing Robyn backend quality, or authoring and improving skill markdown for Robyn engineering workflows.

Code Gen 3 4mo ago
DoubleslashSE

platform-knowledge

by DoubleslashSE

Deep knowledge of GitHub Actions, Railway, Supabase, and Postgres platforms. Use when troubleshooting, configuring, or optimizing any of these platforms.

CI/CD 3 4mo ago