afrexai-database-engineerDatabase Engineering Mastery covers schema design, indexing, query optimization, and migration for PostgreSQL, MySQL, SQLite, supporting OLTP/OLAP workloads.
Install via ClawdBot CLI:
clawdbot install 1kalin/afrexai-database-engineerGrade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Calls external URL not in known-safe list
https://afrexai-cto.github.io/context-packs/Audited Apr 17, 2026 · audit v1.0
Generated Mar 22, 2026
Migrating from a legacy MySQL database to PostgreSQL for better JSONB support and scalability, while redesigning the schema to handle high-concurrency transactions and reporting needs. The skill guides normalization decisions, indexing for product searches, and soft delete patterns for order history.
Designing a HIPAA-compliant database for a healthcare provider, using PostgreSQL with multi-tenancy (schema-per-tenant) to isolate patient data. The skill helps enforce constraints for sensitive information, optimize queries for patient records, and implement audit trails with timestamps.
Building a scalable SaaS application with SQLite for local development and PostgreSQL in production, using the skill's naming conventions and column type decisions. It addresses multi-tenant row-level isolation, indexing strategies for user analytics, and migration scripts for schema updates.
Creating an OLAP database for financial reporting with denormalized tables to speed up aggregations, as per the skill's denormalization triggers. The skill guides using NUMERIC for money, BRIN indexes for time-series data, and compliance with SOX regulations.
Designing a database to store and query time-series data from IoT devices, using PostgreSQL with geospatial types for location tracking. The skill helps with essential table templates for device logs, GIN indexes for JSONB metadata, and optimization for high-volume writes.
Offering expert consulting for businesses needing database design, migration, or optimization, leveraging the skill's frameworks to provide tailored solutions. Revenue comes from hourly rates or project-based fees for implementing schemas and performance tuning.
Building and selling a SaaS tool that automates database schema generation and migration based on the skill's templates and decision trees. Revenue is generated through subscription plans for teams requiring consistent database management across projects.
Providing training courses and certifications on database engineering using the skill's content, targeting developers and IT professionals. Revenue streams include course fees, certification exams, and corporate training packages for upskilling teams.
💬 Integration Tip
Integrate this skill into CI/CD pipelines by automating schema migrations with version-controlled SQL scripts, and use the naming conventions to ensure consistency across development and production environments.
Scored Apr 19, 2026
Use the @steipete/oracle CLI to bundle a prompt plus the right files and get a second-model review (API or browser) for debugging, refactors, design checks, or cross-validation.
Local search/indexing CLI (BM25 + vectors + rerank) with MCP mode.
Use when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question.
Connect to Supabase for database operations, vector search, and storage. Use for storing data, running SQL queries, similarity search with pgvector, and managing tables. Triggers on requests involving databases, vector stores, embeddings, or Supabase specifically.
Use SQLite correctly with proper concurrency, pragmas, and type handling.
Write correct MySQL queries avoiding common pitfalls with character sets, indexes, and locking.