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.

Automates designing and implementing table partitioning strategies to keep large databases performant, optimize time-series workloads, and shorten maintenance windows, with guidance on key selection, SQL scripts, and query tuning.

Handles disaster recovery, PITR, and automated failover for production databases via the database-recovery-manager plugin, streamlining backup validation and recovery testing whenever users ask for database recovery support.

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.

This skill guides the integration of Model Context Protocol (MCP) into Claude Code plugins. It enables plugins to securely connect to external services, APIs, databases, and file systems by exposing capabilities as structured tools. Supports multiple connection methods (stdio, SSE, HTTP, WebSocket) and handles complex authentication flows like OAuth and token-based access for robust tool access.

Automates Neon serverless Postgres workflows via the Composio MCP, letting you list projects and branches, inspect databases, manage roles, and retrieve connection URIs for pipelines and tooling integrations.

Automates NestJS module scaffolding with best-practice templates for backend services, covering Node.js, Python, Go, databases, caching, messaging, and microservices architecture.

Expert guidance on designing highly scalable, distributed NoSQL databases, specifically covering Apache Cassandra and Amazon DynamoDB. This skill emphasizes the 'Query-First' modeling approach, teaching best practices like partitioning, denormalization, single-table design, and avoiding common anti-patterns (e.g., hot partitions, joins) to ensure optimal read/write performance at massive scale.

Guides automation of Notion via Composio’s Rube MCP toolkit, covering setup, tool sequences, parameter expectations, and common pitfalls for pages, databases, blocks, schemas, users, and comments.

A specialized, comprehensive workflow designed for optimizing PostgreSQL databases. It guides users through performance assessment, advanced query tuning (using EXPLAIN ANALYZE), defining optimal indexing strategies, fine-tuning configuration parameters (like shared_buffers), and setting up robust maintenance and monitoring practices for production environments.

Automatically collects comprehensive diagnostic information for Replit workspaces, deployments, and databases. This tool gathers system state, runtime versions, environment variables, network logs, and package details. It is essential for troubleshooting persistent issues or preparing detailed evidence for support tickets.

This comprehensive guide details how to optimize the Replit development environment. It covers setting up run commands, implementing hot reloading for various languages (Node.js, Python), configuring ports, managing development vs. production databases, and leveraging the Replit Agent for powerful AI-assisted coding. Use this guide when setting up a new project or refining your entire dev workflow.