Design multi-tenant PostgreSQL schemas with Row-Level Security and Alembic migrations.
npx skills add https://github.com/itechmeat/llm-code --skill postgresql-itechmeat
Please help me install this Agent Skill. Skill: postgresql Source: https://github.com/itechmeat/llm-code/tree/main/skills/postgresql Command: npx skills add https://github.com/itechmeat/llm-code --skill postgresql-itechmeat
PostgreSQL multi-tenant architectures often struggle with tenant isolation, scalable schema design, and maintaining consistent migrations. This Skill provides best practices to implement Row-Level Security, robust data models, and migration patterns to scale tenants safely. It guides teams through aligning authentication, runtime configuration, and auditing for multi-tenant PostgreSQL deployments.
Start by applying the recommended RLS pattern and migration templates from this skill's README to your PostgreSQL setup, then adapt to your app's ORM layer.
High-intent search queries and answers about installing and using this skill.
Row-Level Security (RLS) enables multi-tenant isolation in PostgreSQL by enforcing per-tenant data access policies across tables and schemas. This Skill provides RLS patterns to guarantee tenant-isolated queries and restrict data visibility based on runtime configuration.
Managing Alembic migrations for PostgreSQL RLS involves applying strategies for schema changes, indexes, and safe rollouts. This Skill guides migration patterns to update RLS policies and schema designs while maintaining zero-downtime deployments across existing tenants.
This PostgreSQL multi-tenant approach integrates with ORMs like Async SQLAlchemy. It requires familiarity with runtime configuration and Row-Level Security concepts to align authentication and tenant isolation within your application's ORM layer.
Runtime configuration drives multi-tenant query tuning in PostgreSQL by setting tenant contexts for high-traffic, tenant-isolated workloads. This Skill outlines performance tuning considerations to optimize query execution across production deployments using runtime variables.
Migrating existing tenants to a new PostgreSQL schema with zero downtime requires aligning Alembic migration strategies with RLS policies. This Skill provides templates to design tenant schemas and execute safe rollouts without disrupting active users.
yuhle-qugAnalyze and optimize database performance across PostgreSQL, MySQL, MongoDB, and SQLite.
jsamuelsen11Analyze PostgreSQL query plans and statistics to identify performance bottlenecks.
Benmore-StudioRun deterministic PCS microservice integration tests with async fixtures and in-memory SQLite.
aleonsaImplement multi-tenant SaaS patterns with PostgreSQL RLS and SQLAlchemy.
