postgresql

Guide PostgreSQL database interactions with SQL queries, schema design, and migrations.

4|Updated Jan 15, 2026

Search Tags:#database #postgresql #migrations #queries #sql #transactions #performance tuning

Ready to run

npx skills add https://github.com/mgd34msu/goodvibes-gemini --skill postgresql-mgd34msu

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: postgresql
Source: https://github.com/mgd34msu/goodvibes-gemini/tree/main/skills/postgresql
Command: npx skills add https://github.com/mgd34msu/goodvibes-gemini --skill postgresql-mgd34msu

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pg, @types/pg, node-pg-migrate, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies complex interactions with PostgreSQL databases, enabling efficient data management, schema design, and performance optimization.

Core Features & Use Cases

SQL Querying: Execute SELECT, INSERT, UPDATE, and DELETE statements with parameterization to prevent injection.
Schema Design & Migrations: Create tables, define relationships, and manage database schema evolution using tools like node-pg-migrate.
Performance Tuning: Analyze query execution plans with EXPLAIN ANALYZE and apply indexing strategies for optimization.
Use Case: You need to design a new database schema for a user management system, including creating tables, defining indexes, and setting up transactions for user registration and order processing.

Quick Start

Use the postgresql skill to connect to a PostgreSQL database using a connection string and execute a simple SELECT NOW() query.

Frequently Asked Questions about postgresql

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I write parameterized PostgreSQL queries in Node.js to prevent SQL injection?▼

Parameterized PostgreSQL queries prevent SQL injection by separating SQL logic from user input. This Skill provides examples for executing SELECT, INSERT, UPDATE, and DELETE statements safely using the Node.js pg library.

How do I manage PostgreSQL schema migrations with node-pg-migrate?▼

PostgreSQL schema migrations are managed using node-pg-migrate to create tables and define relationships. This Skill provides guidance for evolving database schemas and managing structural changes programmatically.

What is the best way to optimize PostgreSQL performance and analyze query execution?▼

PostgreSQL performance tuning is best achieved by analyzing execution plans with EXPLAIN ANALYZE. This Skill demonstrates how to evaluate query performance and apply indexing strategies for optimization.

How does PostgreSQL handle JSONB operations and full-text search?▼

PostgreSQL handles JSONB operations and full-text search through specialized SQL syntax and indexing strategies. This Skill provides comprehensive guidance and code examples for executing these advanced data queries.

How do I ensure transaction management consistency for PostgreSQL user registration?▼

PostgreSQL transaction management ensures consistency by grouping schema design and query operations into atomic units. This Skill covers setting up transactions for reliable user registration and order processing workflows.

Can I use this Skill for designing a Node.js database schema from scratch?▼

Yes, you can use this Skill for designing a Node.js database schema from scratch. It provides comprehensive guidance for creating tables, defining indexes, and managing database schema evolution specifically in Node.js environments.