Automate PostgreSQL and MongoDB patterns for data modeling, indexing, and migrations.
npx skills add https://github.com/opzero1/op1 --skill databases-opzero1
Please help me install this Agent Skill. Skill: databases Source: https://github.com/opzero1/op1/tree/main/packages/install/templates/skill/databases Command: npx skills add https://github.com/opzero1/op1 --skill databases-opzero1
This Skill provides standardized PostgreSQL and MongoDB patterns for queries, indexing, migrations, and performance tuning to accelerate database work and ensure consistency across projects.
Install and load the databases skill, then use the included SQL and MongoDB snippets to perform typical tasks such as creating tables, adding indexes, upserting data, and running simple analytics.
High-intent search queries and answers about installing and using this skill.
Safe PostgreSQL migrations follow standardized patterns for schema changes, index creation, and data backfills to minimize downtime. This Skill provides migration guidelines that ensure reliable data operations by applying transaction-safe DDL patterns and rollback strategies.
MongoDB indexing for aggregation pipelines requires strategic index placement on match-stage fields and sort keys. This Skill delivers indexing guidance and CRUD patterns that optimize aggregation query performance across common analytics pipeline operations.
PostgreSQL upserts and pagination use INSERT ON CONFLICT patterns and keyset pagination to maintain performance at scale. This Skill provides SQL DML snippets that implement reliable upsert logic and efficient pagination queries for backend services.
Standardized SQL DDL patterns ensure consistent data modeling by applying reusable table creation and constraint definitions. This Skill supplies common query patterns and DDL snippets that accelerate database work while maintaining structural consistency across PostgreSQL projects.
JSON handling patterns for MongoDB are needed whenever documents contain nested structures or arrays requiring query and update operations. This Skill covers MongoDB essentials including CRUD operations, JSON data modeling, and indexing strategies for document-based data operations.
PostgreSQL performance tuning relies on specific transaction patterns because proper isolation levels and commit strategies directly impact query throughput. This Skill provides transaction patterns and performance monitoring examples that optimize database operations for backend services.
xukrutdonutExecute SQL queries and manage schemas across PostgreSQL, MySQL, SQLite, MongoDB, and Redis.
skinred78Design schemas, write queries, and administer MongoDB and PostgreSQL databases.
twarogowskiAutomate Bun-based full-stack development workflows with monorepo management, testing, and builds.
sitharaj88Generate Prisma schemas, migrations, queries, and seeding scripts for multiple databases.
