Database

Database management and queries

Showing 1921-1944 of 3662 skills
patricio0312rev

vector-db-setup

by patricio0312rev

Sets up vector databases for semantic search including Pinecone, Chroma, pgvector, and Qdrant with embedding generation and similarity search. Use when users request "vector database", "semantic search", "embeddings storage", "Pinecone setup", or "similarity search".

Database 52 6mo ago
patricio0312rev

agent-orchestration-planner

by patricio0312rev

Designs multi-step agent workflows with tool usage, retry logic, state management, and budget controls. Provides orchestration diagrams, tool execution order, fallback strategies, and cost limits. Use for "AI agents", "agentic workflows", "multi-step AI", or "autonomous systems".

Agents 52 6mo ago
patricio0312rev

rfc-generator

by patricio0312rev

Generates Request for Comments documents for technical proposals including problem statement, solution design, alternatives, risks, and rollout plans. Use for "RFC", "technical proposals", "design docs", or "architecture proposals".

Analytics 52 6mo ago
tommy-ca

research-documentation

by tommy-ca

Research topics and document findings in Notion with organized structure and sources

Academic 52 8mo ago
Xexr

gastown-rig-setup

by Xexr

Use when adding a new Git repository as a Gas Town rig with Dolt-native beads. Triggers on "add a rig", "set up a rig", "onboard repo to Gas Town", "new rig".

Code Gen 16 5mo ago
Logos-Liber

data-engineering

by Logos-Liber

Data pipeline patterns, ETL/ELT best practices, data storage options, and data quality techniques

Processing 16 5mo ago
goncy

nextjs-navigation

by goncy

Provides expert guidance on Next.js App Router navigation, prefetching behavior, and Link component configuration. Use when working with Next.js navigation, Link prefetching, or App Router routing.

Database 16 5mo ago
jgamaraalv

postgresql

by jgamaraalv

"PostgreSQL 16+ reference for writing queries, designing schemas, managing indexes, and optimizing performance. Use when: (1) writing SQL queries (SELECT, INSERT, UPDATE, DELETE, CTEs, window functions, subqueries), (2) designing or altering table schemas (CREATE TABLE, constraints, sequences, data types), (3) choosing or creating indexes (B-tree, GIN, GiST, BRIN, partial, expression), (4) managing transactions and isolation levels (BEGIN/COMMIT, savepoints, MVCC), (5) working with JSONB data and jsonpath, (6) analyzing query performance with EXPLAIN ANALYZE, or (7) using the psql CLI."

Comments 15 5mo ago
ProxiBlue

analyze-m1-module-for-migration

by ProxiBlue

Systematically analyze a Magento 1 module to determine its purpose, usage, and migration requirements for Magento 2. Use when you need to decide whether to migrate a M1 module, find alternatives, or skip it.

Code Review 15 8mo ago
jgamaraalv

typescript-conventions

by jgamaraalv

"TypeScript coding conventions for strict, type-safe projects. Use when: (1) writing or reviewing TypeScript code, (2) choosing between any and unknown, (3) structuring imports with verbatimModuleSyntax, (4) naming functions, booleans, queries, and commands, (5) handling errors with guard clauses and early returns, or (6) avoiding common anti-patterns like primitive obsession, magic strings, and premature abstraction."

Database 15 5mo ago
ProxiBlue

database-query-analysis

by ProxiBlue

Rapid database query execution skill for common Magento 2 data analysis tasks. Leverages database and magento2-dev MCP servers for catalog, order, configuration, and system data retrieval.

Processing 15 5mo ago
ProxiBlue

github-analysis

by ProxiBlue

Systematically analyze GitHub tickets with proper local reproduction. Automatically substitutes production URLs with local DDEV hosts, ensures database sync, downloads missing assets, and reproduces issues locally before proposing solutions.

CLI Tools 15 8mo ago
ProxiBlue

magento-diagnostic

by ProxiBlue

Comprehensive Magento 2 system diagnostic skill that gathers cache status, index status, module information, configuration, logs, and performance metrics for rapid troubleshooting.

Caching 15 5mo ago
open-circle

valibot-usage

by open-circle

Schema validation with Valibot, the modular and type-safe schema library. Use when the user needs to validate data, create schemas, parse inputs, or work with Valibot in their project. Also use when migrating from Zod to Valibot.

Processing 15 6mo ago
ddunnock

problem-definition

by ddunnock

Guide RCCA/8D problem definition using 5W2H and IS/IS NOT analysis. Transforms scattered failure data into precise, measurable problem statements that bound investigation scope without embedding cause or solution. Use when defining problems for root cause analysis, writing D2 sections of 8D reports, analyzing nonconformances, investigating failures, or when user mentions problem definition, problem statement, RCCA, 8D, failure analysis, or corrective action.

Auth 10 5mo ago
eveld

upgrade-plugin

by eveld

Generic migration orchestrator that reads CHANGELOG.md to understand and execute version-specific migrations

Database 10 5mo ago
ddunnock

fmea-analysis

by ddunnock

Conduct Failure Mode and Effects Analysis (FMEA) for systematic identification and risk assessment of potential failures in designs, processes, or systems. Supports DFMEA (Design), PFMEA (Process), and FMEA-MSR (Monitoring & System Response). Uses AIAG-VDA 7-step methodology with Action Priority (AP) risk assessment replacing traditional RPN. Use when analyzing product designs for potential failures, evaluating manufacturing process risks, conducting proactive risk assessment, preparing for APQP/PPAP submissions, investigating field failures, or when user mentions "FMEA", "failure mode", "DFMEA", "PFMEA", "severity occurrence detection", "RPN", "Action Priority", "design risk analysis", or needs to identify and prioritize potential failure modes with their causes and effects.

Processing 10 5mo ago
eveld

gcp-logs

by eveld

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

Cloud 10 5mo ago
ddunnock

five-whys-analysis

by ddunnock

Conduct rigorous 5 Whys root cause analysis with guided questioning, quality scoring, and professional report generation. Use when performing root cause analysis, investigating problems, conducting 5 Whys sessions, troubleshooting recurring issues, or when user mentions "5 whys", "root cause", "why did this happen", "find the cause", or needs to identify underlying causes of defects, failures, or process problems. Includes validation tests, scoring rubric, and countermeasure development.

Processing 10 5mo ago
lv416e

semgrep-rule-variant-creator

by lv416e

Creates language variants of existing Semgrep rules. Use when porting a Semgrep rule to specified target languages. Takes an existing rule and target languages as input, produces independent rule+test directories for each language.

Database 6 5mo ago
greendesertsnow

pocketbase-best-practices

by greendesertsnow

PocketBase development best practices covering collection design, API rules, authentication, SDK usage, query optimization, realtime subscriptions, file handling, and deployment. Use when building PocketBase backends, designing schemas, implementing access control, setting up auth flows, or optimizing performance.

Auth 6 5mo ago
lv416e

performance-profiling

by lv416e

"Use when investigating performance issues, before attempting any optimization - four-phase methodology (baseline measurement, bottleneck profiling, complexity analysis, targeted optimization) that ensures data-driven decisions over gut-feel tuning パフォーマンスの問題を調査する際、最適化を試みる前に使用 - 4フェーズ手法(ベースライン測定、ボトルネックプロファイリング、計算量分析、的を絞った最適化)により、直感的なチューニングではなくデータに基づく判断を保証"

Database 6 5mo ago
joabgonzalez

form-validation

by joabgonzalez

"Form and schema validation across libraries. Trigger: When validating forms, API input, schemas, or runtime data."

Database 6 5mo ago
mgd34msu

state-management

by mgd34msu

"Load PROACTIVELY when task involves application state, data fetching, or form handling. Use when user says \"manage state\", \"add data fetching\", \"set up Zustand\", \"handle form validation\", or \"add React Query\". Covers server state (TanStack Query with caching, optimistic updates), client state (Zustand stores), form state (React Hook Form with Zod validation), URL state (search params, routing), and choosing between state solutions."

Database 6 5mo ago