Design PostgreSQL schemas, queries, migrations for scalable backend systems.
npx skills add https://github.com/kaxuna1/ecomsite --skill postgresql-kaxuna1
Please help me install this Agent Skill. Skill: postgresql Source: https://github.com/kaxuna1/ecomsite/tree/main/.claude/skills/postgresql Command: npx skills add https://github.com/kaxuna1/ecomsite --skill postgresql-kaxuna1
This Skill provides guidance on building robust PostgreSQL databases, including schema design, safe SQL, and migrations for reliable backend systems.
Use this skill to design a new users table with proper indexing and a sample transaction to create a user and associated profile.
High-intent search queries and answers about installing and using this skill.
PostgreSQL schema design with JSONB columns involves structuring relational tables while leveraging JSONB for flexible, semi-structured product data. This approach enables efficient indexing and complex queries for scalable e-commerce workflows.
Database migrations across backend services are managed through versioned migration workflows. This approach ensures safe schema evolution and iterative product feature deployment without compromising existing data integrity.
Preventing SQL injection in PostgreSQL requires using parameterized queries. By separating SQL logic from data inputs, parameterized queries enforce strict typing and prevent malicious code execution during database transactions.
Transaction patterns in PostgreSQL group multiple database operations into a single atomic unit. By using explicit transaction blocks, you ensure that all operations succeed together or roll back completely, maintaining data integrity.
Yes, TypeScript snippets can implement PostgreSQL transactions and safe SQL. Parameterized query patterns are provided with example TypeScript code to execute secure database operations within scalable backend systems.
tinkermonkeyDefine and validate object data structures using JSON Schema Draft 7.
langchain-aiApply versioned Up/Down migration scripts with rollback and validation support.
constructive-ioDesign PostgreSQL schemas and build type-safe Drizzle ORM queries in TypeScript.
roanbrasilDesign PostgreSQL schemas, indexes, and zero-downtime migrations.
