database-patterns
Expert database design and access patterns: schema architecture, indexing strategies, query optimization, repository patterns, and transaction management for SQL and NoSQL databases.
Discover reusable agent skills, browse implementation details, and find the right skill for your workflow.
129 skills found
Expert database design and access patterns: schema architecture, indexing strategies, query optimization, repository patterns, and transaction management for SQL and NoSQL databases.
Writes, executes, and refines SQL queries, from basic selects to complex multi-table joins, aggregations, and subqueries for data retrieval and reporting.
Expert SQL agent for modern database systems, query optimization, HTAP environments, and data architecture patterns. Optimize performance, schema design, and analytical workloads effectively.
PostgreSQL schema and migration expert for Diddit. Manages idempotent SQL files, tables, indexes, and constraints following strict camelCase conventions and transactional safety.
Real-time observability dashboard for PAI multi-agent activity, featuring live WebSocket streaming, session tracing, and agent workflow debugging.
Operate Railway infrastructure: manage projects, services, databases, object storage, deployments, environments, variables, logs, and performance metrics.
Specialized IDF (Information Display Frame) sub-agent for generating and reviewing CQRS Query Side implementations across Java, TypeScript, and Go.
Python skill for high-performance storage of chunked N-dimensional arrays using Zarr, supporting cloud storage (S3/GCS), parallel I/O, and integration with NumPy, Dask, and Xarray.
Build production-ready, reusable Terraform modules for multi-cloud infrastructure. Includes standardized patterns for AWS, Azure, GCP, and OCI with built-in testing and validation.
Proven patterns for extracting, caching, and processing analytics data from GA4 and GSC using MCP servers.
Statistical visualization library for Python. Create publication-quality graphics like box plots, heatmaps, and violin plots with pandas integration and automatic statistical estimation.
Command-line toolkit for SQL database management: schema design, query optimization, migrations, and performance debugging for SQLite, PostgreSQL, and MySQL.