Database

Database management and queries

Showing 1609-1632 of 4352 skills
alexandru

jspecify-nullness

by alexandru

JSpecify nullness annotations for Java APIs and tooling. Use when adopting or migrating JSpecify annotations, designing null-safe Java signatures and generics, or interpreting tool conformance and Kotlin interop.

Comments 51 8mo ago
Altinity

altinity-expert-clickhouse-metrics

by Altinity

Real-time monitoring of ClickHouse metrics, events, and asynchronous metrics. Use for load average, connections, queue monitoring, and resource saturation.

Database 17 9mo ago
odysseus0

rss-digest

by odysseus0

"Agentic RSS digest using the feed CLI. Fetch, triage, and summarize RSS feeds to surface high-signal posts. Use when: (1) reading RSS feeds or catching up on news, (2) user asks for a digest, roundup, or summary of recent posts, (3) user asks what's new or interesting today, (4) user mentions feed, RSS, or blogs."

Database 16 8mo ago
pacphi

qgis

by pacphi

Geospatial analysis and GIS operations via QGIS. Use for calculating distances, buffering zones, coordinate transforms (EPSG:4326 to EPSG:3857), layer operations, geoprocessing (intersect, union, clip), and exporting map images. Requires QGIS running on Display :1 with MCP plugin enabled.

Code Gen 16 9mo ago
lis186

pattern-finder

by lis186

Find implementation examples and design patterns in the codebase. Use when user asks "how to implement X", "how does this project do X", "show me examples of X", "where is X implemented", or needs to follow existing code conventions.

API Dev 48 10mo ago
petekp

architecture-decision-records

by petekp

Write and maintain Architecture Decision Records (ADRs) following best practices for technical decision documentation. Use when documenting significant technical decisions, reviewing past architectural choices, or establishing decision processes.

Code Gen 48 8mo ago
petekp

aesthetic-guide

by petekp

Research a UI design aesthetic and produce exhaustive, implementation-ready design guidelines for coding agents. Use when the user names an aesthetic (brutalist, glassmorphism, retro-futuristic, Swiss modernist, Apple HIG, neumorphism, minimalism, cyberpunk, Material Design, art deco, vaporwave, etc.) and wants a complete style guide with exact CSS values, color palettes, component states, animations, and typography — detailed enough for a coding agent to faithfully implement the aesthetic with zero ambiguity.

Database 48 8mo ago
frankxai

OCI Services Expert

by frankxai

Expert guidance on Oracle Cloud Infrastructure services, cloud architecture patterns, cost optimization, deployment strategies, and OCI best practices for enterprise solutions

Processing 47 12mo ago
rnavarych

role-architect:scalability-analysis

by rnavarych

Scalability analysis expertise including horizontal vs vertical scaling, sharding strategies, read/write splitting, eventual consistency patterns, CQRS for scale, back-of-envelope calculations, and caching layer design.

Caching 15 7mo ago
rnavarych

role-architect:cost-modeling

by rnavarych

Cost modeling expertise including infrastructure cost estimation, TCO calculation, build vs buy analysis, pricing model comparison, ROI projection, cost growth modeling, and breakeven analysis.

Database 15 7mo ago
rnavarych

role-database:capacity-planning

by rnavarych

Database capacity and growth planning. Storage growth estimation, IOPS requirements, memory sizing (buffer pool, shared_buffers), connection count estimation, sharding triggers, read replica scaling, cost estimation per cloud provider. Load testing (pgbench, sysbench, YCSB, HammerDB). When to shard vs scale up vs read replicas. Use when planning database capacity, sizing infrastructure, or evaluating scaling strategies.

Caching 15 7mo ago
Gentleman-Programming

elixir-antipatterns

by Gentleman-Programming

Core catalog of 8 critical Elixir/Phoenix anti-patterns covering error handling, separation of concerns, Ecto queries, and testing. Trigger: During Elixir code review, refactoring sessions, or when writing Phoenix/Ecto code.

Database 660 9mo ago
rnavarych

role-backend:database-implementation

by rnavarych

Implements database layers using Prisma, Drizzle ORM, TypeORM, SQLAlchemy 2.0, GORM, Diesel, Entity Framework Core 8, Hibernate/Panache, ActiveRecord, Ecto, Sequelize, Kysely, and Knex. Covers migrations, connection pooling, read replicas, query optimization, transaction management, and database testing with Testcontainers and factories. Use when setting up database access, writing migrations, optimizing queries, or configuring connection pools.

Processing 15 7mo ago
rnavarych

role-database:backup-recovery

by rnavarych

Backup strategies and disaster recovery across all database engines. Full, incremental, differential backups. PITR (Point-in-Time Recovery). PostgreSQL (pg_dump, pgBackRest, Barman, WAL archiving), MySQL (mysqldump, XtraBackup, Clone Plugin), MongoDB (mongodump, Atlas backup), Redis (RDB, AOF). RPO/RTO planning, backup verification, cloud-native backup. Use when designing backup strategies, implementing disaster recovery, or troubleshooting data recovery.

Caching 15 7mo ago
Heyvhuang

tool-better-auth

by Heyvhuang

Use when implementing authentication with Better Auth in a TypeScript/Next.js app (session strategy, providers, cookies, CSRF, redirects, middleware, and security best practices).

Auth 338 9mo ago
Heyvhuang

mcp-stripe

by Heyvhuang

"Stripe MCP transaction operations skill. Execute transaction operations via Stripe MCP server (https://mcp.stripe.com): customer management, products/prices, invoices, payment links, subscriptions, refunds, dispute handling, balance queries. Triggers: user requests Stripe operations including create customer, create product, create invoice, generate payment link, query transactions, process refunds, manage subscriptions, view disputes, check balance, etc."

Code Gen 338 9mo ago
Heyvhuang

supabase

by Heyvhuang

"Database operations for Supabase: query/write/migration/logs/type generation. Triggers: query/statistics/export/insert/update/delete/fix/backfill/migrate/logs/alerts/type generation. Does not trigger for: pure architecture discussion or code planning. Write operations require confirmation; UPDATE/DELETE without WHERE is refused. MCP is optional — works with CLI/Console too."

Database 338 9mo ago
Heyvhuang

tool-schema-markup

by Heyvhuang

When the user wants to add, fix, or optimize schema markup and structured data on their site. Also use when the user mentions "schema markup," "structured data," "JSON-LD," "rich snippets," "schema.org," "FAQ schema," "product schema," "review schema," or "breadcrumb schema." For broader SEO issues, see review-seo-audit.

Processing 338 9mo ago
Heyvhuang

mcp-supabase

by Heyvhuang

"Execute database operations via Supabase MCP (query/write/migration/logs/type generation). Triggers: query/statistics/export/insert/update/delete/fix/backfill/migrate/logs/alerts/type generation. Does not trigger for: pure architecture discussion or code planning. Write operations require confirmation; UPDATE/DELETE without WHERE is refused."

Database 338 9mo ago
SnakeO

debug:laravel

by SnakeO

Debug Laravel applications systematically with this comprehensive troubleshooting skill. Covers class/namespace errors, database SQLSTATE issues, route problems (404/405), Blade template errors, middleware issues (CSRF/auth), queue job failures, and cache/session problems. Provides structured four-phase debugging methodology with Laravel Telescope, Debugbar, Artisan tinker, and logging best practices for development and production environments.

CLI Tools 9 9mo ago
SnakeO

refactor:laravel

by SnakeO

Refactor PHP/Laravel code to improve maintainability, readability, and adherence to best practices. This skill transforms code using modern PHP 8.3+/8.4+ features like property hooks and typed constants, Laravel 11+ patterns including Actions and simplified structure, and SOLID principles. It addresses fat controllers, code duplication, N+1 queries, and missing type declarations. Apply when you notice business logic in controllers or legacy PHP patterns.

Code Gen 9 9mo ago
makenotion

notion-knowledge-capture

by makenotion

Transforms conversations and discussions into structured documentation pages in Notion. Captures insights, decisions, and knowledge from chat context, formats appropriately, and saves to wikis or databases with proper organization and linking for easy discovery.

Code Gen 499 10mo ago
personamanagmentlayer

kubernetes-expert

by personamanagmentlayer

Expert-level Kubernetes cluster management, deployment strategies, networking, and production operations

Database 44 9mo ago
paid-tw

payment-help

by paid-tw

Analyzes user requirements and recommends the best Taiwan payment gateway. Provides comparison between NewebPay, ECPay, and PAYUNi based on specific needs. Use when choosing a payment solution or comparing 金流服務.

API Dev 284 9mo ago