Database

Database management and queries

Showing 1321-1344 of 3660 skills
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 14 4mo ago
ahmed3elshaer

core-data

by ahmed3elshaer

Core Data for iOS persistence. Data models, fetch requests, background contexts, and SwiftData migration.

Processing 59 5mo ago
ThePrimeagen

skills

by ThePrimeagen

Cloudflare R2 bucket binding usage rules

Cloud 231 5mo ago
ThePrimeagen

skills

by ThePrimeagen

Cloudflare Assets binding usage rules

Cloud 231 5mo ago
TechNickAI

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"

API Dev 24 5mo ago
x-cmd

jpa-patterns

by x-cmd

JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.

Code Gen 24 5mo ago
majesticlabs-dev

pandas-coder

by majesticlabs-dev

DataFrame manipulation with chunked processing, memory optimization, and vectorized operations.

Processing 44 5mo ago
majesticlabs-dev

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.

CI/CD 44 5mo ago
majesticlabs-dev

etl-incremental-patterns

by majesticlabs-dev

Incremental data loading patterns including backfill strategies, CDC, timestamp-based loads, and pipeline orchestration.

CI/CD 44 5mo ago
majesticlabs-dev

pandera-validation

by majesticlabs-dev

DataFrame schema validation using pandera. Schema definitions, column checks, and decorator-based validation.

Code Review 44 6mo ago
majesticlabs-dev

parquet-coder

by majesticlabs-dev

Columnar file patterns including partitioning, predicate pushdown, and schema evolution.

Processing 44 5mo ago
majesticlabs-dev

sql-patterns

by majesticlabs-dev

Advanced SQL patterns including window functions, CTEs, recursive queries, and optimization techniques.

Automation 44 5mo ago
majesticlabs-dev

dbt-coder

by majesticlabs-dev

dbt (data build tool) patterns for model organization, incremental strategies, and testing.

Database 44 5mo ago
majesticlabs-dev

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.

Code Review 44 6mo ago
dykyi-roman

adr-template

by dykyi-roman

Generates Architecture Decision Records (ADR) for PHP projects. Creates structured decision documentation with context, decision, and consequences.

Processing 92 5mo ago
hummingbot

lp-agent

by hummingbot

Manage concentrated liquidity (CLMM) positions on DEXs like Meteora and Raydium. Create, monitor, and rebalance LP positions automatically.

Code Review 32 4mo ago
BagelHole

asset-inventory

by BagelHole

Maintain IT asset inventory and configuration management database. Track hardware, software, and cloud resources. Use when managing IT assets.

Cloud 42 5mo ago
varunchopra

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).

Auth 13 1mo ago
dougkeefe

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

Code Review 13 5mo 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 450 7mo ago
dojoengine

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.

Code Gen 53 6mo ago
hainamchung

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.

Auth 53 5mo ago
hainamchung

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.

Processing 53 5mo ago
hainamchung

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.

Code Gen 53 5mo ago