Skills
.Work. You
Rest

postgresql-expert

Community

Master PostgreSQL patterns with Bun.sql.

Software Engineering#performance#postgresql#pgvector#plpgsql#bun.sql#sql-patterns#jsonb
Authorlammesen
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill provides expert PostgreSQL guidance using Bun's native SQL client, covering patterns for queries, schema design, JSON/JSONB operations, full-text search, indexing, PL/pgSQL, pgvector, and performance optimization. It helps developers build scalable, maintainable database access in Bun-powered apps.

Core Features & Use Cases

  • Bun.sql integration: Write and manage PostgreSQL queries directly with Bun.sql for fast, type-safe access.
  • Comprehensive patterns: Access a complete set of database techniques—queries, schemas, JSON/JSONB, FTS, indexing, PL/pgSQL, pgvector, and performance tuning.
  • Use Case: When architecting a Bun-based Node service that talks to PostgreSQL, apply these patterns to implement robust data access, efficient reads, and reliable writes.

Quick Start

Start by connecting Bun.sql to your PostgreSQL database and applying the patterns to build a solid data layer, then iterate with small, safe migrations.

Dependency Matrix

Required Modules

None required

Components

references

đź’» Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: postgresql-expert
Download link: https://github.com/lammesen/skills/archive/main.zip#postgresql-expert

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.