Skill UI

Expert guidance for designing distributed NoSQL databases like Cassandra and DynamoDB. Covers query-first modeling, partition key selection, single-table design, denormalization, and avoiding hot partitions in high-scale systems.

Automates Notion pages, databases, blocks, comments, and users through Composio’s Notion toolkit via Rube MCP, guiding connection setup, tool sequencing, and schema-aware workflows for operations.

This skill provides a comprehensive guide for backing up and restoring Odoo instances, covering PostgreSQL databases and filestores. It includes automation scripts, cloud storage integration, and step-by-step recovery procedures to ensure data safety and business continuity.

This skill provides a complete production-ready Docker setup for Odoo ERP. It includes PostgreSQL database configuration, persistent volume management, environment variable handling, and optional Nginx reverse proxy with SSL support. Suitable for local development, VPS deployment, and troubleshooting container issues. Covers docker-compose.yml generation and odoo.conf tuning for optimal performance.

A comprehensive guide and methodology for identifying, measuring, and fixing performance bottlenecks across the entire stack. This skill covers optimizing database queries (e.g., N+1 problems, missing indexes), improving API efficiency (caching, parallel processing), and enhancing frontend performance (memoization, code splitting, image optimization). It emphasizes the critical 'Measure First' principle to ensure all optimizations are data-driven and effective.

Operate MySQL-compatible databases on PlanetScale with branching workflows, safe migrations, and production rollouts. Covers CLI installation, database management, deploy requests, connection proxying, Prisma integration, and Vitess features.

A comprehensive guide maintained by Supabase for optimizing Postgres performance. It provides critical rules and best practices across query performance, schema design, connection management, and security (including RLS). Use this skill when writing, reviewing, or optimizing complex SQL queries, database schemas, or configurations to ensure optimal database health and performance.

Execute safe read-only SQL queries against PostgreSQL databases with multi-connection support and defense-in-depth write protection. Ideal for schema exploration, data retrieval, and analysis without risking accidental writes.

Design efficient PostgreSQL schemas using best practices for data types, indexing, and constraints. Covers normalization, partitioning, and performance optimization for scalable database systems.

A comprehensive guide for using psql, PostgreSQL's interactive terminal. Covers connection methods, security best practices, environment variables, script execution, and database object inspection commands. Essential for database administrators and developers managing PostgreSQL instances via command line.

Administer, optimize, and secure PostgreSQL databases in development and production environments. Covers installation, configuration tuning, backups, streaming replication, and security best practices.

Expert in Prisma ORM covering schema design, migrations, query optimization, relations modeling, and database operations for PostgreSQL, MySQL, and SQLite. Provides diagnostics, best practices, and prioritized fixes for common issues.