Design and optimize MongoDB and PostgreSQL schemas for OLTP and OLAP workloads.
npx skills add https://github.com/lukebaze/forex-rebate-bot --skill databases-lukebaze
Please help me install this Agent Skill. Skill: databases Source: https://github.com/lukebaze/forex-rebate-bot/tree/main/.opencode/skill/databases Command: npx skills add https://github.com/lukebaze/forex-rebate-bot --skill databases-lukebaze
This Skill provides structured guidance for designing, normalizing, and optimizing databases across MongoDB and PostgreSQL, covering OLTP and OLAP use cases to ensure scalable, maintainable data models.
Design and review a MongoDB or PostgreSQL schema for a new feature, applying the included OLTP/OLAP rules and migration guidelines.
High-intent search queries and answers about installing and using this skill.
Database schema design for transactional and analytical workloads involves applying structured normalization, indexing strategies, and best-practice patterns. This covers OLTP and OLAP contexts to produce scalable, maintainable data models across PostgreSQL and MongoDB.
Planning database migrations for PostgreSQL and MongoDB requires following structured migration guidelines and best-practice patterns. This ensures consistent schema changes and backward compatibility, minimizing downtime during schema transitions across document and relational databases.
Structuring indexing strategies for NoSQL and SQL databases requires analyzing specific query patterns and workload types. By applying performance tuning rules, you can optimize both document and relational databases for scalable analytical and transactional data access.
Yes, this database design approach works for both OLTP and OLAP contexts. It provides structured reference libraries and best-practice patterns to normalize and optimize schemas, ensuring scalable models for both transactional and analytical workloads across MongoDB and PostgreSQL.
Choosing between PostgreSQL and MongoDB depends on workload requirements: PostgreSQL suits relational OLTP and OLAP contexts needing structured consistency, while MongoDB fits document-based NoSQL workloads. Cross-database integration scenarios can also combine both for specific query patterns.
samhvw8Guide MongoDB and PostgreSQL schema design, query optimization, migrations, and backups.
marcoamuOptimize PostgreSQL queries, indexes, and schemas for transactional and analytical workloads.
capaas2Create and maintain Opensquad best-practice files with frontmatter validation and cross-reference updates.
boomNDSDesign SQL and NoSQL database schemas with normalization and indexing strategies.
