What tools does pg-gleam support?

The skill is specifically designed for the Gleam stack, supporting Squirrel/Parrot for SQL generation, POG for connection pooling, and Cigogne for database migrations.

How are primary keys handled in this skill?

The skill promotes the use of UUIDv7 primary keys via the pg_uuidv7 extension, ensuring time-sortable and globally unique identifiers.

Does it support Postgres Row-Level Security (RLS)?

Yes, it includes specialized patterns for implementing RLS using session variables to manage multi-tenant security efficiently.

How does this skill improve query performance?

It provides detailed best practices for composite, covering, and partial indexes, alongside guidance on using EXPLAIN ANALYZE to diagnose bottlenecks.

Can it help with Gleam-specific data type mapping?

Yes, it provides a strict mapping table to ensure Postgres types like bigint (for money) and enums translate correctly into Gleam types through the POG driver.

PG Gleam Postgres Guide

Name: PG Gleam Postgres Guide
Author: aboio-labs

byaboio-labs

•

数据库管理

Optimizes Postgres performance and schema design for Gleam-based backend stacks using Squirrel, POG, and Cigogne.

PG Gleam is a specialized skill designed for developers working within the Gleam programming language ecosystem to build high-performance, type-safe database layers. It provides expert guidance on Postgres schema design, query optimization, and connection management specifically tailored for use with POG, Squirrel/Parrot, and Cigogne. By enforcing specific conventions like UUIDv7 primary keys, session-variable RLS, and precise Gleam-to-SQL type mappings, this skill ensures your database architecture is scalable, secure, and perfectly aligned with functional programming patterns.

主要功能

012 GitHub stars

02Postgres schema design patterns optimized for Squirrel and Parrot SQL generation

03Standardized implementation of Row-Level Security (RLS) using session variables

04Strict naming conventions and data type mappings for Gleam compatibility

05Comprehensive guides for advanced features like JSONB indexing and partitioning

06Performance tuning for POG connection pooling and binary protocol communication

使用场景

01Designing a high-performance database schema for a new Gleam web application

02Implementing secure multi-tenant architectures using Postgres RLS and Cigogne migrations

03Auditing existing SQL queries for N+1 performance issues and index optimization

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add aboio-labs/aboio-skills pg-gleam

For use in Claude.ai and ChatGPT

Download Skill