Skill UI

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.

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.

An end-to-end workflow for building robust, production-ready Python backend APIs. This guide covers all stages, including project scaffolding, SQLAlchemy database integration, Pydantic validation, implementing JWT/OAuth2 authentication, comprehensive error handling, unit testing, and Docker deployment for modern microservices.

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.

A comprehensive guide detailing security best practices for building and deploying applications on the Replit platform. Learn how to properly manage sensitive data using Replit Secrets (AES-256 encryption), implement secure service-to-service authentication via REPL_IDENTITY tokens, validate custom headers, and prevent common vulnerabilities like hardcoded API keys and SQL injection. Essential for auditing and securing production environments.

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 report template creation within data analytics by guiding SQL, visualization, statistics, and BI best practices, generating ready-to-use configurations and validating outputs.