数据库

数据库管理与查询

显示 1105-1128 / 共 4344 个技能
wasp-lang

plugin-help

wasp-lang

Shows the Wasp plugin's available features, commands, and skills.

代码生成 14 9个月前
AltimateAI

finding-expensive-queries

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.

数据库 129 9个月前
AltimateAI

creating-dbt-models

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 工具 129 9个月前
AltimateAI

developing-incremental-models

AltimateAI

Develops and troubleshoots dbt incremental models. Use when working with incremental materialization for: (1) Creating new incremental models (choosing strategy, unique_key, partition) (2) Task mentions "incremental", "append", "merge", "upsert", or "late arriving data" (3) Troubleshooting incremental failures (merge errors, partition pruning, schema drift) (4) Optimizing incremental performance or deciding table vs incremental Guides through strategy selection, handles common incremental gotchas.

数据处理 129 8个月前
AltimateAI

refactoring-dbt-models

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.

数据库 129 9个月前
AltimateAI

documenting-dbt-models

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.

数据库 129 9个月前
AltimateAI

migrating-sql-to-dbt

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.

CLI 工具 129 9个月前
CloudAI-X

convex-backend

CloudAI-X

Convex backend development guidelines. Use when writing Convex functions, schemas, queries, mutations, actions, or any backend code in a Convex project. Triggers on tasks involving Convex database operations, real-time subscriptions, file storage, or serverless functions.

数据库 1421 8个月前
CloudAI-X

optimizing-performance

CloudAI-X

Analyzes and optimizes application performance across frontend, backend, and database layers. Use when diagnosing slowness, improving load times, optimizing queries, reducing bundle size, or when asked about performance issues.

数据处理 1421 8个月前
xpnobug

web-dev

xpnobug

Web 开发最佳实践和现代前端技术栈指导

代码生成 9 9个月前
noartem

laravel-performance-eager-loading

noartem

Prevent N+1 queries by eager loading; enable lazy-loading protection in non-production; choose selective fields

数据库 13 9个月前
noartem

laravel-performance-caching

noartem

Use framework caches and value/query caching to reduce work; add tags, locks, and explicit invalidation strategies for correctness

缓存 13 9个月前
noartem

laravel-filesystem-uploads

noartem

Store and serve files via Storage; set visibility, generate URLs, and handle streaming safely

缓存 13 9个月前
noartem

laravel-migrations-and-factories

noartem

Safe database change patterns; when to modify vs add migrations; always pair models with migrations and factories; seeding guidance

代码生成 13 9个月前
neilotoole

sq

neilotoole

Guides use of the sq CLI to query SQL databases and tabular files with SLQ (sq's jq-like query language) or native SQL, manage sources, choose output formats, and run inspect, diff, and table commands. Use when the user mentions sq, SLQ, wrangling CSV/Excel/JSON/DB data, cross-source joins, or command-line data pipelines after installing sq from https://sq.io.

数据处理 2573 6个月前
AltimateAI

testing-dbt-models

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.

数据库 129 9个月前
exceptionless

TanStack Query

exceptionless

Data fetching and caching with TanStack Query in Svelte. Query patterns, mutations, cache invalidation, WebSocket-driven updates, and optimistic updates. Keywords: createQuery, createMutation, TanStack Query, query keys, cache invalidation, optimistic updates, refetch, stale time, @exceptionless/fetchclient, WebSocket

数据处理 2456 9个月前
narumiruna

mcp-builder

narumiruna

"Comprehensive guide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Covers both Python (FastMCP) and Node/TypeScript (MCP SDK) implementations."

数据处理 11 10个月前
eduardofuncao

Squix Skill for AI Coding Agents

eduardofuncao

squix run with no args — opens $EDITOR

数据处理 275 6个月前
ils15

agent-coordination

ils15

"Master guide to orchestrating the multi-agent system for rapid, TDD-driven feature development with guaranteed code quality and audit trails"

认证鉴权 12 8个月前
ils15

performance-optimization

ils15

"Performance optimization - query analysis, N+1 detection, caching, indexing strategies"

缓存 12 8个月前
ils15

9-agent-coordination

ils15

"Master guide to orchestrating the multi-agent system for rapid, TDD-driven feature development with guaranteed code quality and audit trails"

认证鉴权 12 8个月前
ils15

fastapi-async-patterns

ils15

Create async FastAPI endpoints with proper error handling, dependency injection, service/repository patterns, and type safety. Includes async database queries, pagination, filtering, and Gemini integration.

代码生成 12 8个月前
Microck

better-auth

Microck

Implement authentication and authorization with Better Auth - a framework-agnostic TypeScript authentication framework. Features include email/password authentication with verification, OAuth providers (Google, GitHub, Discord, etc.), two-factor authentication (TOTP, SMS), passkeys/WebAuthn support, session management, role-based access control (RBAC), rate limiting, and database adapters. Use when adding authentication to applications, implementing OAuth flows, setting up 2FA/MFA, managing user sessions, configuring authorization rules, or building secure authentication systems for web applications.

认证鉴权 408 10个月前