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.
127 skills found
Expert database design and access patterns: schema architecture, indexing strategies, query optimization, repository patterns, and transaction management for SQL and NoSQL databases.
High-performance in-memory DataFrame library for Python and Rust. Features lazy evaluation, parallel execution, and an Apache Arrow backend for efficient ETL, data processing, and faster pandas alternatives.
Writes, executes, and refines SQL queries, from basic selects to complex multi-table joins, aggregations, and subqueries for data retrieval and reporting.
Generate optimized SQL queries from natural language. Supports BigQuery, PostgreSQL, MySQL, and Snowflake. Analyze database schemas, interpret business requirements, and output ready-to-run queries with explanations.
Database schema validation, data integrity testing, migration validation, transaction isolation, and query performance testing. Ensure ACID compliance and referential integrity for data-driven applications.
Python coding assistant providing best practices, PEP 8 enforcement, automated testing with pytest, and dependency management using uv.
A comprehensive guide for designing high-performance, maintainable PostgreSQL database schemas, covering best practices, data types, indexing, and advanced features.
Expert guidance for Django asynchronous task processing with Celery. Best practices for task design, worker configuration, error handling, periodic tasks, and production monitoring.
Convert natural language queries to safe, optimized SQL. Automates database interactions with schema awareness and parameterized query generation.
Apply reality-first coding standards: intentional naming, focused functions, guard clauses, and deterministic side effects, with no speculative features.
Essential guide to llmemory for document storage and search: installation, database setup with pgvector, document ingestion, hybrid/semantic retrieval, and building RAG systems with multi-tenant support.
Implementation patterns for MERIDIAN autonomous AI agents using Claude API, including BaseAgent lifecycle, structured tool use, token budget enforcement, and cron scheduling.