Skill UI

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

PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management.

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.

Performs OWASP-guided security scans on PostgreSQL and MySQL databases via the database-security-scanner plugin, identifying weak passwords, SQL injection risks, and misconfigurations while generating reports and remediation advice.

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.

A comprehensive skill for optimizing complex SQL queries, designing robust database schemas, and troubleshooting performance bottlenecks across various dialects (PostgreSQL, MySQL, etc.). Use this when queries are slow, complex set-based logic is needed (CTEs, Window Functions), or when structuring/migrating a database schema. It provides detailed query plan analysis, advanced indexing strategies, and industry best practices.