Database

Database management and queries

Showing 937-960 of 3659 skills
olorehq

olore-t3-env-latest

by olorehq

Local t3-env documentation reference (latest). T3 Env documentation. Use for type-safe environment variable validation with Zod/Valibot, Next.js and Nuxt integration, and runtime env configuration.

Database 67 5mo ago
olorehq

olore-neon-latest

by olorehq

Local Neon documentation reference (latest). Neon serverless Postgres documentation. Use for database branching, autoscaling, connection pooling, data API, extensions, migrations, and PostgreSQL features.

API Dev 67 5mo ago
olorehq

olore-tanstack-query-3

by olorehq

Local TanStack Query v3 (React Query) documentation reference. Server state management, data fetching, caching, queries, mutations, and React integration.

Caching 67 5mo ago
olorehq

olore-zod-3

by olorehq

Local Zod v3 documentation reference. Use when asked about Zod schema validation, TypeScript type inference, error handling, or migration from earlier versions.

Database 67 5mo ago
olorehq

olore-zod-latest

by olorehq

Local zod documentation reference (latest). Zod schema validation documentation. Use for TypeScript type inference, parsing, error handling, and schema composition.

Database 67 5mo ago
olorehq

olore-trpc-latest

by olorehq

Local tRPC documentation reference (latest). tRPC documentation. Use for end-to-end typesafe APIs, React Query integration, Next.js adapters, subscriptions, and TypeScript RPC.

Database 67 5mo ago
olorehq

olore-turso-latest

by olorehq

Local Turso documentation reference (latest). Use for libSQL, SQLite at the edge, embedded replicas, Turso CLI, and database sync.

API Dev 67 5mo ago
olorehq

olore-convex-latest

by olorehq

Local Convex documentation reference (latest). Convex backend documentation. Use for real-time database, serverless functions, file storage, authentication, scheduling, search, AI agents, and full-stack TypeScript development.

Auth 67 5mo ago
olorehq

olore-drizzle-latest

by olorehq

Local Drizzle ORM documentation reference (latest). Use when asked about Drizzle ORM queries, schema definitions, migrations, column types, PostgreSQL/MySQL/SQLite dialects, Drizzle Kit, or database operations.

Code Gen 67 5mo ago
olorehq

olore-tanstack-query-4

by olorehq

Local TanStack Query documentation reference (v4). Use for server state management, data fetching, caching, queries, mutations, and React/Vue/Solid/Angular query integration.

Caching 67 5mo ago
olorehq

olore-tanstack-query-latest

by olorehq

Local TanStack Query documentation reference (latest). Use for server state management, data fetching, caching, queries, mutations, and React/Vue/Solid/Angular query integration.

Caching 67 5mo ago
olorehq

olore-prisma-latest

by olorehq

Local Prisma documentation reference. Use when asked about Prisma ORM, Prisma Client, Prisma Schema, migrations, database queries, Prisma Accelerate, or Prisma Postgres.

Database 67 5mo ago
olorehq

olore-supabase-latest

by olorehq

Local Supabase documentation reference (latest). Use for Supabase Auth, Database, Storage, Edge Functions, Realtime, and client SDKs.

Auth 67 5mo ago
aahl

mcp-vods

by aahl

用于追剧/追番的技能,为AI提供搜索影视播放地址的能力,并支持在小米电视上直接播放。当用户想搜索影视、动漫、短剧、综艺等节目信息或更新进度时使用此技能。

Database 145 5mo ago
lyndonkl

adr-architecture

by lyndonkl

Use when documenting significant technical or architectural decisions that need context, rationale, and consequences recorded. Invoke when choosing between technology options, making infrastructure decisions, establishing standards, migrating systems, or when team needs to understand why a decision was made. Use when user mentions ADR, architecture decision, technical decision record, or decision documentation.

Code Gen 135 8mo ago
lyndonkl

knowledge-graph-construction

by lyndonkl

Use when designing and building knowledge graphs from unstructured data. Invoke when user mentions entity extraction, schema design, LPG vs RDF, graph data model, ontology alignment, knowledge graph construction, or building a KG for RAG. Provides extraction pipelines, schema patterns, and data model selection guidance.

Processing 135 5mo ago
lyndonkl

decomposition-reconstruction

by lyndonkl

Use when dealing with complex systems that need simplification, identifying bottlenecks or critical failure points, redesigning architecture or processes for better performance, breaking down problems that feel overwhelming, analyzing dependencies to understand ripple effects, user mentions "this is too complex", "where's the bottleneck", "how do we redesign this", "what are the key components", or when optimization requires understanding how parts interact.

Processing 135 8mo ago
lyndonkl

graphrag-system-design

by lyndonkl

Use when designing complete GraphRAG systems that combine graph retrieval with LLM reasoning. Invoke when user mentions GraphRAG system, technology stack, Neo4j with LLM, LangChain graph, LlamaIndex knowledge graph, community detection for RAG, hybrid symbol-vector integration, production GraphRAG, or domain-specific graph RAG. Provides architecture design, technology selection, and domain customization guidance.

Analytics 135 5mo ago
lyndonkl

data-schema-knowledge-modeling

by lyndonkl

Use when designing database schemas, need to model domain entities and relationships clearly, building knowledge graphs or ontologies, creating API data models, defining system boundaries and invariants, migrating between data models, establishing taxonomies or hierarchies, user mentions "schema", "data model", "entities", "relationships", "ontology", "knowledge graph", or when scattered/inconsistent data structures need formalization.

Processing 135 8mo ago
AltimateAI

finding-expensive-queries

by AltimateAI

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 expensive", or "slowest queries" (3) Analyzing warehouse costs or identifying optimization candidates (4) Finding queries that scan the most data or have the most spillage Returns ranked list of queries with metrics and optimization recommendations.

Database 111 6mo ago
AltimateAI

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.

CLI Tools 111 6mo ago
AltimateAI

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.

Database 111 6mo ago
AltimateAI

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.

Database 111 6mo ago
AltimateAI

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.

Processing 111 6mo ago