Skill UI

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.

This guide provides comprehensive patterns for designing and implementing secure multi-tenant SaaS applications using shared databases. It covers critical techniques like Row-Level Security (RLS) in PostgreSQL, implementing tenant-aware middleware in TypeScript (Express/Fastify), and enforcing data scoping at the ORM level (Prisma/Drizzle). Learn how to prevent data leakage and manage tenant isolation across shared schemas.

Zero-knowledge SSH ops CLI for server health checks, docker/systemd control, log tailing, Postgres introspection, and declarative deploys without exposing credentials to the agent.

This skill provides comprehensive guidelines for optimizing Postgres database performance and security. It covers query optimization, schema design, connection management, Row-Level Security, and concurrency handling. Use it when writing SQL, reviewing database configurations, or implementing indexes. Based on Supabase best practices to ensure efficient and secure database operations for production environments.