- Home
- /
- Categories
- /
- Database
Database
Database management and queries
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.
core-data
by ahmed3elshaer
Core Data for iOS persistence. Data models, fetch requests, background contexts, and SwiftData migration.
skills
by ThePrimeagen
Cloudflare R2 bucket binding usage rules
skills
by ThePrimeagen
Cloudflare Assets binding usage rules
fireflies
by TechNickAI
"Use when finding meeting transcripts, searching Fireflies recordings, getting action items from calls, or answering 'what was discussed in the meeting' questions"
jpa-patterns
by x-cmd
JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.
pandas-coder
by majesticlabs-dev
DataFrame manipulation with chunked processing, memory optimization, and vectorized operations.
digitalocean-coder
by majesticlabs-dev
This skill guides writing DigitalOcean infrastructure with OpenTofu/Terraform. Use when provisioning Droplets, VPCs, Managed Databases, Firewalls, or other DO resources.
etl-incremental-patterns
by majesticlabs-dev
Incremental data loading patterns including backfill strategies, CDC, timestamp-based loads, and pipeline orchestration.
pandera-validation
by majesticlabs-dev
DataFrame schema validation using pandera. Schema definitions, column checks, and decorator-based validation.
parquet-coder
by majesticlabs-dev
Columnar file patterns including partitioning, predicate pushdown, and schema evolution.
sql-patterns
by majesticlabs-dev
Advanced SQL patterns including window functions, CTEs, recursive queries, and optimization techniques.
dbt-coder
by majesticlabs-dev
dbt (data build tool) patterns for model organization, incremental strategies, and testing.
infra-security-review
by majesticlabs-dev
Security patterns and checklists for reviewing Infrastructure-as-Code. Covers Terraform/OpenTofu state, secrets, network, compute, database, and storage security.
adr-template
by dykyi-roman
Generates Architecture Decision Records (ADR) for PHP projects. Creates structured decision documentation with context, decision, and consequences.
lp-agent
by hummingbot
Manage concentrated liquidity (CLMM) positions on DEXs like Meteora and Raydium. Create, monitor, and rebalance LP positions automatically.
asset-inventory
by BagelHole
Maintain IT asset inventory and configuration management database. Track hardware, software, and cloud resources. Use when managing IT assets.
postkit
by varunchopra
PostgreSQL-native identity, configuration, metering, and job queues. SQL functions that work with any language or driver. Use when working with user management, sessions, permissions, access control, login/logout, MFA, password resets, relationship-based access, versioned configuration, prompts, usage tracking, quotas, billing periods, or background jobs in PostgreSQL. Covers authn (user/session management), authz (ReBAC permissions), config (versioned key-value storage), meter (usage tracking with reservations), and queue (job scheduling with retries and dead letters).
gc-review-im
by dougkeefe
Use when reviewing database schemas, migrations, and data access code for GoC Information Management compliance - checks mandatory metadata (Creator, Date, Language, Classification), retention policies, soft deletes, searchability, and audit requirements per Directive on Service and Digital
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.
dojo-migrate
by dojoengine
Manage world migrations, handle breaking changes, and upgrade Dojo versions. Use when updating deployed worlds, migrating to new versions, or handling schema changes.
better-auth
by hainamchung
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.
backend-development
by hainamchung
Backend API design, database architecture, microservices patterns, and test-driven development. Use for designing APIs, database schemas, or backend system architecture.
architecture-designer
by hainamchung
Use when designing new system architecture, reviewing existing designs, or making architectural decisions. Invoke for system design, architecture review, design patterns, ADRs, scalability planning.