Database

Database management and queries

Showing 3193-3216 of 3623 skills
hydric-org

hydric-liquidity-pools-indexer-user

by hydric-org

Comprehensive guide for interacting with the hydric Liquidity Pools Indexer (Envio/HyperIndex). Use this skill when you need to (1) Query real-time Liquidity Pool data like TVL, Volume, Fees, or Yields/APY, (2) Fetch cross-chain token metadata and prices, (3) Aggregate protocol data (Uniswap, etc.), (4) Retrieve historical time-series data for generic analytics

API Dev 0 3mo ago
aiko-atami

eslint-prettier-migration

by aiko-atami

Migrate projects from ESLint and/or Prettier to BiomeJS with safe sequencing, flag selection (--include-inspired, --include-nursery), config-translation review, ignore parity checks, and post-migration stabilization. Use when users ask to replace ESLint/Prettier, port legacy or flat ESLint configs, migrate Prettier options/ignores, or troubleshoot migration command limits and behavior differences.

Code Review 0 3mo ago
Crawlio-app

observe

by Crawlio-app

Use this skill when the user asks to "check observations", "what did Crawlio see", "show crawl timeline", "query the observation log", or wants to review what happened during a crawl session. Queries the append-only observation log with filtering by host, source, operation, and time range.

Code Review 0 3mo ago
cristiano-pacheco

go-integration-tests

by cristiano-pacheco

Generate comprehensive Go integration tests using testify suite patterns with real database and infrastructure dependencies. Use when creating or updating integration test files, testing use cases against real databases, verifying end-to-end flows, or when asked to add integration test coverage for Go code.

Database 0 3mo ago
totophe

sequelize-7

by totophe

"Comprehensive reference for Sequelize v7 (alpha), the TypeScript-first Node.js ORM supporting PostgreSQL, MySQL, MariaDB, SQLite, MSSQL, DB2, and Snowflake. Use when working with @sequelize/core package: defining models with decorators, writing database queries (CRUD, associations, raw SQL), managing transactions, hooks, connection pools, setting up associations, or migrating from Sequelize v6 to v7."

Code Gen 0 3mo ago
Nomik94

alembic

by Nomik94

Alembic DB 마이그레이션 패턴 레퍼런스. Use when: 마이그레이션 생성, DB 스키마 변경, 테이블 추가, 컬럼 변경, alembic revision, autogenerate, downgrade, 롤백, 마이그레이션 이력, 데이터 마이그레이션, bulk data update, 인덱스 추가, 외래키 변경, alembic.ini 설정, env.py 설정, 마이그레이션 충돌 해결. NOT for: SQLAlchemy 모델 정의, ORM 쿼리 패턴.

CI/CD 0 3mo ago
ofershap

drizzle-best-practices

by ofershap

Drizzle ORM done right. Schema design, relations, type-safe queries, migrations, and performance

Code Gen 0 3mo ago
shanibofizae-glitch

backend-development

by shanibofizae-glitch

Backend API design, database architecture, microservices patterns, and test-driven development. Use for designing APIs, database schemas, or backend system architecture.

Processing 0 1d ago
tstelzer

effect-http-server

by tstelzer

Explains how to define http servers with effect. Use only when a top-level server is, or needs to be written in effect.

API Dev 0 3mo ago
hrdtbs

api-design-principles

by hrdtbs

Design intuitive, scalable, and maintainable REST and GraphQL APIs. Covers resource naming, HTTP methods, status codes, schema design, and best practices.

API Dev 0 3mo ago
Protagonistss

react-best-practices

by Protagonistss

React 开发最佳实践指南,涵盖组件设计、Hooks 使用、状态管理及性能优化。

API Dev 0 4mo ago
fusionet24

code-review-assistant

by fusionet24

Activates when reviewing code to identify quality issues, security vulnerabilities, and suggest improvements

Code Review 0 5mo ago
samChang72

graphql

by samChang72

"GraphQL gives clients exactly the data they need - no more, no less. One endpoint, typed schema, introspection. But the flexibility that makes it powerful also makes it dangerous. Without proper controls, clients can craft queries that bring down your server. This skill covers schema design, resolvers, DataLoader for N+1 prevention, federation for microservices, and client integration with Apollo/urql. Key insight: GraphQL is a contract. The schema is the API documentation. Design it carefully."

API Dev 0 4mo ago
legout

data-engineering-storage-lakehouse

by legout

"Lakehouse table formats: Delta Lake, Apache Iceberg, and Apache Hudi for ACID transactions, schema evolution, and time travel on data lakes."

Processing 0 3mo ago
janjaszczak

mcp-grafana

by janjaszczak

Query dashboards/logs/alerts to support incident analysis and regressions. Use when troubleshooting involves observability, incidents, latency, error rates.

Database 0 4mo ago
djankies

managing-client-lifecycle

by djankies

Manage PrismaClient lifecycle with graceful shutdown, proper disconnect timing, and logging configuration. Use when setting up application shutdown handlers, configuring logging for development or production, or implementing proper connection cleanup in Node.js servers, serverless functions, or test suites.

Database 0 6mo ago
Sytex

monitor

by Sytex

Read-only infrastructure monitoring. Use when user asks about pod status, deployments, CPU, memory, restarts, 502 errors, slowness, cluster health, or wants to check if environments are running correctly.

Database 0 3mo ago
iulspop

integration-tests

by iulspop

Generates integration tests for server actions, database operations, and API routes using Vitest with the "given/should" prose format. Use when testing infrastructure facades, route actions, session management, or multi-service interactions.

Processing 0 3mo ago
vircung

Elixir Phoenix Framework Skill

by vircung

Use this skill to build Phoenix applications efficiently using generators, implement LiveView patterns correctly, and follow Phoenix conventions for scalable web applications.

Database 0 4mo ago
aaronvanston

convex-queries

by aaronvanston

Best practices for Convex database queries, indexes, and filtering. Use when writing or reviewing database queries in Convex, working with .filter(), .collect(), .withIndex(), defining indexes in schema.ts, or optimizing query performance.

Database 0 4mo ago
habibium

drizzle-v1

by habibium

Drizzle ORM v1 RC upgrade and migration patterns. Use when upgrading drizzle-orm/drizzle-kit to v1 (beta), migrating from Relational Queries v1 to v2, updating relations schema definitions, or working with new v1 features like through for many-to-many relations and object-based where/orderBy syntax.

Code Gen 0 4mo ago
jcastillotx

Windows Privilege Escalation

by jcastillotx

This skill should be used when the user asks to "escalate privileges on Windows," "find Windows privesc vectors," "enumerate Windows for privilege escalation," "exploit Windows misconfigurations," or "perform post-exploitation privilege escalation." It provides comprehensive guidance for discovering and exploiting privilege escalation vulnerabilities in Windows environments.

CLI Tools 0 4mo ago
zhongjis

docker

by zhongjis

Docker and Docker Compose patterns for local development, container security, networking, volume strategies, and multi-service orchestration. Use when working with Docker, Dockerfiles, docker-compose, container builds, or container debugging.

Caching 0 3mo ago
HowardKao-1130

collect_interests

by HowardKao-1130

Load recorded user interests from the personal library.

Academic 0 3mo ago