- Home
- /
- Categories
- /
- Database
Database
Database management and queries
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.
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.
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.
supabase
by salavender
Database, auth, and backend expertise for Supabase operations in [PROJECT_NAME]
compound-docs
by salavender
Document solved problems for knowledge persistence
postgres-patterns
by joneqian
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
backend-patterns
by joneqian
Backend architecture patterns, API design, database optimization, and server-side best practices for Node.js, Express, NestJS, FastAPI, and Next.js API routes.
code_formatter
by vuralserhat86
Otomatik kod formatlama, Prettier/ESLint entegrasyonu ve kod stil tutarlılığı rehberi.
backend_database
by vuralserhat86
Repository pattern, transactions, caching ve query optimization.
drizzle_orm
by vuralserhat86
Type-safe ORM for Cloudflare D1 databases using Drizzle. Provides patterns for schema definition, migrations, and type-safe queries. Prevents transaction errors and schema mismatches. Includes templates for strict TypeScript usage.
arch_decisions
by vuralserhat86
ADR template, database selection, capacity planning ve scalability.
data_visualization
by vuralserhat86
Generate data visualizations, plots, and charts. Analyzes data structure to select optimal visualization types. supports bar charts, line graphs, and scatter plots for clarity.
event_driven
by vuralserhat86
Structure systems around asynchronous, event-based communication to decouple producers and consumers for improved scalability and resilience. Use when building loosely coupled systems with asynchronous message-based communication.
better_auth
by vuralserhat86
The ultimate authentication and authorization skill. Implement login, signin, signup, registration, OAuth, 2FA, MFA, passkeys, and user session management. Secure your application with RBAC and access control.
database_design
by vuralserhat86
Schema tasarımı, migration stratejileri, indexing, query optimization ve database best practices.
data_transform
by vuralserhat86
Transform raw data into analytical assets using ETL/ELT patterns, SQL (dbt), Python (pandas/polars/PySpark), and orchestration (Airflow). Use when building data pipelines, implementing incremental models, migrating from pandas to polars, or orchestrating multi-step transformations with testing and quality checks.
database_migration
by vuralserhat86
Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations, or implementing zero-downtime deployment strategies.
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.
swift-snapshot-testing
by nonameplum
A library for snapshot testing in Swift with support for views, images, and custom formats
questdb
by questdb
Use this skill whenever working with QuestDB — a high-performance time-series database. Trigger on any mention of QuestDB, time-series SQL with SAMPLE BY, LATEST ON, ASOF JOIN, ILP ingestion, or the questdb Python/Go/Java/Rust/.NET client libraries. Also trigger when writing Grafana queries against QuestDB, creating materialized views for time-series rollups, working with order book or financial market data in QuestDB, or any SQL that involves designated timestamps or time-partitioned tables. QuestDB extends SQL with unique time-series keywords — standard PostgreSQL or MySQL patterns will fail. Always read this skill before writing QuestDB SQL to avoid hallucinating incorrect syntax.
accessory-setup-kit
by nonameplum
AccessorySetupKit for privacy-preserving discovery and setup of Bluetooth, Wi-Fi, or Wi-Fi Aware accessories. Use for discovery sessions, picker-based authorization, migration, accessory renaming or removal, custom filtering, and required Info.plist declarations.
swift-sharing
by nonameplum
A library for sharing state across your app with persistence and observation support
testcontainers-go
by testcontainers
A comprehensive guide for using Testcontainers for Go to write reliable integration tests with Docker containers in Go projects. Supports 62+ pre-configured modules for databases, message queues, cloud services, and more. Use this skill when writing Go integration tests, setting up test databases (PostgreSQL, MySQL, Redis, MongoDB), testing with message queues (Kafka, RabbitMQ), or creating container-based test infrastructure. Covers modules, generic containers, networking, cleanup, wait strategies, CI/CD integration, and common anti-patterns.
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