Database Management Agent Skills
Discover Agent Skills for database management. Browse 25skills for Claude, ChatGPT & Codex.
SQL Query Optimizer
Analyzes and optimizes SQL queries for PostgreSQL and MySQL to improve performance and reduce execution time.
dbt Coder
Standardizes dbt project architecture and SQL transformation patterns for scalable analytics engineering.
Production ETL Patterns
Orchestrates production-grade Extract-Transform-Load (ETL) pipelines using reliability patterns and incremental load strategies.
Parquet Data Engineering
Optimizes columnar data storage using Parquet patterns for partitioning, predicate pushdown, and schema evolution.
Litestream for Rails
Configures continuous SQLite backups for Rails 8+ applications using Litestream and S3-compatible storage.
SQL Patterns & Optimization
Provides advanced SQL design patterns and optimization techniques for efficient data engineering and complex query construction.
Supabase Data Manager
Manages Supabase databases through direct REST API calls for CRUD operations and advanced data filtering.
Rails AI Solid Stack (Jobs & Cache)
Configures database-backed background jobs, caching, and WebSockets using the Rails 8 Solid Stack while strictly excluding Redis and Sidekiq.
SQL
Writes and optimizes SQLite queries, schemas, and migrations using standardized best practices and specific implementation patterns.
PostgreSQL Database Administration
Manages and optimizes PostgreSQL databases for customer support environments, including schema design, performance tuning, and advanced query implementation.
Event Sourcing
Implements event sourcing and CQRS patterns to maintain a full history of state changes through immutable event streams.
dbt Data Transformation
Streamlines analytics engineering workflows by implementing modular SQL transformations, automated testing, and comprehensive data documentation using dbt.
Kafka Stream Processing
Architects and implements scalable event-driven systems using Apache Kafka for real-time data processing and high-throughput messaging.
Pre-Dev Data Modeling
Defines technology-agnostic data entities, relationships, and ownership to ensure robust system architecture before database selection.
Database Management Patterns
Optimizes data architecture and performance across SQL and NoSQL systems through comprehensive schema design, indexing strategies, and scaling patterns.
Neon Serverless Postgres
Streamlines database development by providing expert guidance on Neon's serverless architecture, branching features, and driver integrations.
PostgreSQL Database Engineering
Optimizes and manages professional PostgreSQL environments through advanced indexing strategies, query tuning, and high-availability architecture patterns.
Vector Database Management
Manages and optimizes vector databases like Pinecone, Weaviate, and Chroma for semantic search, RAG systems, and similarity-based AI applications.
Redis State Management
Implements high-performance Redis patterns for caching, session management, and distributed state coordination.
Psycopg PostgreSQL Adapter
Simplifies PostgreSQL database operations in Python with specialized support for connection pooling, asynchronous I/O, and secure query execution.
SQLAlchemy ORM Expert
Implements professional-grade SQLAlchemy ORM patterns and database optimizations for modern Python applications.
Alembic Database Migration
Manages complex database schema evolutions and data migrations using Alembic and SQLAlchemy with a focus on production stability.
Database WAL Recovery
Recovers data from SQLite Write-Ahead Log (WAL) files by identifying, analyzing, and decrypting corrupted or inaccessible database components.
SQL Query Optimization
Optimizes SQL queries for maximum performance by identifying bottlenecks, rewriting inefficient subqueries, and implementing high-performance patterns like window functions and CTEs.
Firebase Firestore Specialist
Optimizes Firebase Firestore implementation with expert NoSQL modeling, real-time synchronization, and advanced Security Rules configuration.
SPARQL University Querying
Provides specialized guidance for constructing and verifying SPARQL queries against RDF and Turtle datasets, specifically tailored for academic and university data structures.
SPARQL University
Constructs and verifies complex SPARQL queries for RDF datasets with a focus on academic ontologies and graph pattern matching.
Database WAL Recovery
Provides technical procedures and systematic workflows for recovering data from corrupted, encrypted, or inaccessible SQLite Write-Ahead Log (WAL) files.
SQLite DB Truncation Recovery
Recovers data from corrupted or truncated SQLite databases by manually parsing binary structures when standard tools fail.
Query Optimization
Optimizes SQL queries through systematic performance benchmarking, execution plan analysis, and iterative refinement across multiple database engines.
Scroll for more results...