Skill UI

Provides PostgreSQL optimization advice covering index design, query plan inspection, partitioning, JSONB tweaks, connection pooling, and tuning checkpoints to stabilize OLTP workloads.

Quick reference of PostgreSQL best practices covering indexing cheatsheets, data type choices, security policies, and configuration templates to guide optimization and troubleshooting workflows.

This skill provides comprehensive expertise for senior database administrators to optimize and manage PostgreSQL databases at an advanced level. Use it for deep query analysis via EXPLAIN ANALYZE, implementing advanced features like JSONB indexing, configuring streaming or logical replication, and maintaining database health through VACUUM tuning and monitoring pg_stat views. Ideal for building highly available, high-performance, and resilient system architectures.

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

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.

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.

This comprehensive workflow guides developers through building a production-ready, full-stack web application entirely within the Replit environment. It covers setting up the entire architecture, including Express/Flask backend logic, robust PostgreSQL database integration for persistent data, implementing secure user authentication using Replit Auth, and managing file uploads via Object Storage. It is the definitive guide for launching a complex, scalable SaaS project from scratch.

Comprehensive guide to managing data securely in Replit applications. This skill covers three core storage systems: PostgreSQL for structured data and complex queries; Replit KV Database for caching and session management; and Object Storage for file uploads and blobs. Learn best practices including parameterized queries, TTL implementation, and secure data access patterns.

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 guide provides a comprehensive reference architecture for building robust, production-grade applications on Replit. It covers best-practice project layouts, system-level configurations (like replit.nix), data layer strategies (PostgreSQL, KV, Object Storage), and secure deployment techniques. Use it when starting a new Replit project, optimizing existing codebases, or establishing enterprise-level architectural standards.

This guide provides production-ready coding patterns for interacting with various built-in Replit services. It covers best practices for setting up singleton clients, implementing robust error handling, and creating type-safe wrappers for Key-Value Database, Object Storage, PostgreSQL, and Auth middleware. Ideal for developers building complex Replit integrations or establishing standardized data access layers.

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.