Skill UI

Provides comprehensive patterns for data synchronization, ETL processes, and data migration specifically for MaintainX. Use this when needing to keep data consistent between MaintainX and external databases, data warehouses (like BigQuery), or when performing bulk data exports to formats like CSV. It covers incremental syncing, full exports, and data reconciliation checks.

This deep-dive guide provides a comprehensive framework for migrating complex operational data into the MaintainX platform. It systematically guides users through assessing source data quality from legacy CMMS systems (like Maximo), spreadsheets, or custom databases. The process covers essential steps including data assessment, schema mapping, and executing robust ETL processes for work orders and assets, ensuring a smooth re-platforming transition.

Manages database schema migrations by generating timestamped up/down scripts for PostgreSQL, MySQL, SQLite, or MongoDB, letting you create, apply, or rollback changes safely when handling schema updates.

Guides designing and implementing horizontal database sharding, covering key selection, migration planning, and cross-shard coordination for scalable systems.

Manages complete database testing workflows by generating realistic test data, wrapping tests in automatic transactions, and validating schema integrity to keep migrations and interactions reliable.

This comprehensive skill manages the entire lifecycle of database testing, ensuring data integrity and system reliability. It covers setting up isolated test environments (using Docker or in-memory databases), executing migrations, and implementing robust test isolation strategies (such as transaction rollback). Use cases include verifying CRUD operations, validating referential constraints, performance benchmarking (EXPLAIN ANALYZE), and ensuring backward compatibility across multiple databases (PostgreSQL, MySQL, MongoDB) and ORMs.

A comprehensive toolset for planning, validating, and executing complex system, database, and infrastructure migrations with zero downtime. It covers critical phases like schema evolution (Expand-Contract), API compatibility checks, risk assessment, and generating automated rollback runbooks. Essential for high-risk transitions where business continuity is paramount.

An expert assistant providing deep knowledge and best practices for Prisma ORM. It covers the entire lifecycle of database interaction, including optimal schema design, relation modeling, safe migration workflows, and advanced query optimization techniques (addressing N+1 issues and implementing raw queries) across PostgreSQL, MySQL, and SQLite.

A comprehensive guide for migrating existing applications from platforms like Heroku, Railway, Vercel, and local development environments to Replit. It covers critical steps such as converting configuration files (Procfile to .replit), adapting to Replit's Nix-based system, and performing database migrations (PostgreSQL, MongoDB). Essential for developers upgrading or moving their deployment stack.

This comprehensive guide outlines the necessary steps for major Replit environment upgrades and data migration. It covers updating Nix channels, upgrading runtimes (Node.js, Python), and migrating critical data from Replit KV databases to PostgreSQL or Object Storage. It also details switching between deployment types, ensuring a smooth and stable transition for production applications.

Automates environment prep, service orchestration, and cleanup for executing integration test suites, covering database setup, migrations, and optional coverage reports.

A comprehensive toolset for the full backend development lifecycle. This suite enables developers to scaffold API routes from OpenAPI specifications, manage complex database migrations and optimization (PostgreSQL), and perform rigorous load/performance testing. It supports building robust microservices, securing REST APIs, and ensuring system scalability.