Database

Database management and queries

Showing 2257-2280 of 3628 skills
andrueandersoncs

Effect AI

by andrueandersoncs

This skill should be used when the user asks about "Effect AI", "@effect/ai", "LLM integration", "AI tool use", "AI execution planning", "building AI agents", "AI providers", "structured AI output", "AI completions", "Effect OpenAI", "Effect Anthropic", or needs to understand how Effect integrates with AI/LLM services.

Database 8 4mo ago
hieutrtr

project-planner

by hieutrtr

Project planning and feature breakdown for Python/React full-stack projects. Use during the planning phase when breaking down feature requests, user stories, or product requirements into implementation plans. Guides identification of affected files and modules, defines acceptance criteria, assesses risks, and estimates overall complexity. Produces module maps, risk assessments, and acceptance criteria. Does NOT cover architecture decisions (use system-architecture), implementation (use python-backend-expert or react-frontend-expert), or atomic task decomposition (use task-decomposition).

Code Gen 8 4mo ago
andrueandersoncs

Resource Management

by andrueandersoncs

This skill should be used when the user asks about "Effect resources", "acquireRelease", "Scope", "finalizers", "resource cleanup", "Effect.addFinalizer", "Effect.ensuring", "scoped effects", "resource lifecycle", "bracket pattern", "safe resource handling", "database connections", "file handles", or needs to understand how Effect guarantees resource cleanup.

Database 8 4mo ago
andrueandersoncs

Pattern Matching

by andrueandersoncs

This skill should be used when the user asks about "Effect Match", "pattern matching", "Match.type", "Match.tag", "Match.when", "Schema.is()", "Schema.is with Match", "exhaustive matching", "discriminated unions", "Match.value", "converting switch to Match", "converting if/else to Match", "TaggedClass with Match", or needs to understand how Effect provides type-safe exhaustive pattern matching.

Database 8 4mo ago
andrueandersoncs

Code Style

by andrueandersoncs

This skill should be used EVERY TIME you're writing TypeScript with Effect, especially when the user asks about "Effect best practices", "Effect code style", "idiomatic Effect", "functional programming", "no loops", "no for loops", "avoid imperative", "Effect Array", "Effect Record", "Effect Struct", "Effect Tuple", "Effect Predicate", "Schema-first", "Match-first", "when to use Schema", "when to use Match", "branded types", "dual APIs", "Effect guidelines", "do notation", "Effect.gen", "pipe vs method chaining", "Effect naming conventions", "Effect project structure", "data modeling in Effect", or needs to understand idiomatic Effect-TS patterns and conventions.

Database 8 4mo ago
xfstudio

architecture

by xfstudio

Architectural decision-making framework. Requirements analysis, trade-off evaluation, ADR documentation. Use when making architecture decisions or analyzing system design.

API Dev 8 4mo ago
hieutrtr

react-frontend-expert

by hieutrtr

React/TypeScript frontend implementation patterns. Use during the implementation phase when creating or modifying React components, custom hooks, pages, data fetching logic with TanStack Query, forms, or routing. Covers component structure, hooks rules, custom hook design (useAuth, useDebounce, usePagination), TypeScript strict-mode conventions, form handling, accessibility requirements, and project structure. Does NOT cover testing (use react-testing-patterns), E2E testing (use e2e-testing), or deployment.

Accessibility 8 4mo ago
derKlinke

ios-cloud-sync-diag

by derKlinke

Use when debugging 'file not syncing', 'CloudKit error', 'sync conflict', 'iCloud upload failed', 'ubiquitous item error', 'data not appearing on other devices', 'CKError', 'quota exceeded' - systematic iCloud sync diagnostics for both CloudKit and iCloud Drive

Code Review 8 3mo ago
eveld

gcp-logs

by eveld

Query GCP Cloud Logging for errors, service logs, and request traces. Use when investigating GCP-hosted services.

Cloud 8 4mo ago
harperaa

injection-vulnerabilities-ai-generated-code

by harperaa

Understand how AI generates SQL injection, command injection, and XSS vulnerabilities. Use this skill when you need to learn about injection attack patterns in AI code, see real-world examples of injection vulnerabilities, understand why AI generates insecure database queries, or recognize vulnerable code patterns. Triggers include "SQL injection AI", "command injection", "XSS vulnerabilities", "injection attacks", "AI database queries", "shell injection", "cross-site scripting AI code".

CLI Tools 8 7mo ago
andrueandersoncs

Error Management

by andrueandersoncs

This skill should be used when the user asks about "Effect errors", "typed errors", "error handling", "Effect.catchAll", "Effect.catchTag", "Effect.mapError", "Effect.orElse", "error accumulation", "defects vs errors", "expected errors", "unexpected errors", "sandboxing", "retrying", "timeout", "Effect.cause", "TaggedError", "Schema.TaggedError", or needs to understand how Effect handles failures in the error channel.

Database 8 4mo ago
andrueandersoncs

Runtime

by andrueandersoncs

This skill should be used when the user asks about "Effect Runtime", "ManagedRuntime", "Effect.Tag", "custom runtime", "runtime layers", "running effects", "runtime configuration", "runtime context", "Effect.runPromise", "Effect.runSync", "runtime scope", or needs to understand how Effect's runtime system executes effects.

Database 8 4mo ago
G1Joshi

dbt

by G1Joshi

dbt data transformation with SQL. Use for data pipelines.

Code Gen 8 3mo ago
hieutrtr

system-architecture

by hieutrtr

System architecture guidance for Python/React full-stack projects. Use during the design phase when making architectural decisions — component boundaries, service layer design, data flow patterns, database schema planning, and technology trade-off analysis. Covers FastAPI layer architecture (Routes/Services/Repositories/Models), React component hierarchy, state management, and cross-cutting concerns (auth, errors, logging). Produces architecture documents and ADRs. Does NOT cover implementation (use python-backend-expert or react-frontend-expert) or API contract design (use api-design-patterns).

API Dev 8 4mo ago
G1Joshi

spark

by G1Joshi

Apache Spark distributed computing. Use for big data processing.

API Dev 8 3mo ago
Ceeon

zoxide-manage

by Ceeon

管理 zoxide 目录记录。 触发词:"添加目录到 zoxide"、"zoxide add"、"zoxide 删除"、"zoxide remove"、 "查看 zoxide 目录"、"zoxide 列表"、"zoxide 记录"、"初始化 zoxide"。

CLI Tools 8 4mo ago
andrueandersoncs

Configuration

by andrueandersoncs

This skill should be used when the user asks about "Effect Config", "environment variables", "configuration management", "Config.string", "Config.number", "ConfigProvider", "Config.nested", "Config.withDefault", "Config.redacted", "sensitive values", "config validation", "loading config from JSON", "config schema", or needs to understand how Effect handles application configuration.

Database 8 4mo ago
Ganbin

4d-v21

by Ganbin

Comprehensive 4D v21 development expert with embedded official documentation. Covers ORDA patterns, entity classes, data model classes, queries, classic methods, data types, error handling, forms, events, web server, and REST API. Use when working with 4D files (.4dm), 4D language questions, 4D project structure, entity classes, ORDA queries, database operations, form development, web server configuration, REST API usage, or any 4D-specific syntax issue. Includes full official 4D v21 documentation for on-demand retrieval. Triggers on: .4dm files, 4D code, ORDA, entity selection, dataclass, 4D query, 4D form, 4D web server, 4D REST, 4D command, 4D collection, 4D object.

API Dev 8 4mo ago
deusyu

qweather

by deusyu

天气查询 — 实时天气、天气预报、生活指数、城市搜索。数据源为和风天气 (QWeather)。 触发词: 天气, 气温, 下雨, 预报, weather, forecast, 穿什么, 洗车, 紫外线, UV, 空气, 今天天气, 明天天气, 北京天气, 或任何 "[城市] 天气" 格式的输入。

API Dev 8 3mo ago
wispbit-ai

sqlalchemy-alembic-expert-best-practices-code-review

by wispbit-ai

SQLAlchemy ORM and Alembic migration best practices for building safe, performant database schemas. This skill should be used when writing, reviewing, or refactoring SQLAlchemy models, Alembic migrations, or database query patterns. Triggers on tasks involving SQLAlchemy ORM, Alembic migrations, database schema changes, or query optimization.

Code Review 8 3mo ago
andrueandersoncs

Schema

by andrueandersoncs

This skill should be used when the user asks about "Effect Schema", "Schema.Struct", "Schema.decodeUnknown", "data validation", "parsing", "Schema.transform", "Schema filters", "Schema annotations", "JSON Schema", "Schema.Class", "Schema branded types", "encoding", "decoding", "Schema.parseJson", or needs to understand how Effect handles data validation and transformation.

Comments 8 4mo ago
wispbit-ai

graphql-expert-best-practices

by wispbit-ai

GraphQL performance optimization and best practices for building scalable APIs. This skill should be used when writing, reviewing, or refactoring GraphQL schemas, resolvers, or query execution code. Triggers on tasks involving GraphQL APIs, resolver optimization, query performance, or data fetching patterns.

API Dev 8 3mo ago
Nice-Wolf-Studio

supabase-realtime

by Nice-Wolf-Studio

Subscribe to realtime changes in Supabase using WebSocket connections. Use for listening to database changes, presence tracking, and broadcast messaging.

CLI Tools 19 7mo ago
AutumnsGrove

sql-expert

by AutumnsGrove

"Expert SQL query writing, optimization, and database schema design with support for PostgreSQL, MySQL, SQLite, and SQL Server. Use when working with databases for: (1) Writing complex SQL queries with joins, subqueries, and window functions, (2) Optimizing slow queries and analyzing execution plans, (3) Designing database schemas with proper normalization, (4) Creating indexes and improving query performance, (5) Writing migrations and handling schema changes, (6) Debugging SQL errors and query issues"

Code Gen 15 7mo ago