Postgres

Browse agent skills tagged with Postgres and compare related workflows across the directory.

30 skills
A
postgres-patterns

by affaan-m

postgres-patterns is a practical PostgreSQL quick-reference skill for query optimization, schema design, indexing, Row Level Security, and connection pooling. It helps Database Engineering workflows make faster, more reliable decisions using compact best practices rather than a generic prompt.

Database Engineering
Favorites 0GitHub 156.2k
A
kotlin-exposed-patterns

by affaan-m

kotlin-exposed-patterns is a practical guide for Kotlin database engineering with JetBrains Exposed. It covers DSL queries, DAO pattern, newSuspendedTransaction, HikariCP, Flyway migrations, and repository boundaries for maintainable data access.

Database Engineering
Favorites 0GitHub 156.2k
A
jpa-patterns

by affaan-m

jpa-patterns is a practical JPA/Hibernate guide for Spring Boot backend development. It covers entity design, relationships, query tuning, transactions, auditing, pagination, and pooling to help reduce ORM mistakes and improve persistence performance.

Backend Development
Favorites 0GitHub 156.2k
A
database-migrations

by affaan-m

The database-migrations skill helps backend teams plan safe schema changes, data backfills, rollbacks, and zero-downtime deploys for PostgreSQL, MySQL, and common ORMs. Use it for production-safe database-migrations guide work when you need clear steps, fewer locks, and reversible changes.

Backend Development
Favorites 0GitHub 156.1k
A
clickhouse-io

by affaan-m

clickhouse-io is a ClickHouse-focused skill for schema design, analytical SQL, ingestion patterns, and performance tuning. Use it to guide MergeTree choices, partitioning, materialized views, and workload-specific query optimization.

Database Engineering
Favorites 0GitHub 156.1k
A
backend-patterns

by affaan-m

backend-patterns is a backend development skill for Node.js, Express, and Next.js API routes. It helps with API design, repository/service/controller layering, validation, caching, background jobs, and database optimization so you can build cleaner server-side systems with less guesswork.

Backend Development
Favorites 0GitHub 156.1k
S
fullstack-developer

by Shubhamsaboo

The fullstack-developer skill is a reusable prompt package for modern JavaScript and TypeScript web app work across React, Next.js, Node.js, APIs, databases, auth, and deployment. It is best for multi-layer planning and implementation, with a single SKILL.md file that defines scope and workflow rather than providing scripts or templates.

Full-Stack Development
Favorites 0GitHub 104.2k
W
sql-optimization-patterns

by wshobson

sql-optimization-patterns helps diagnose slow SQL with EXPLAIN analysis, indexing strategy, join tuning, pagination fixes, and practical query rewrite guidance for database engineering teams.

Database Engineering
Favorites 0GitHub 32.6k
W
postgresql-table-design

by wshobson

postgresql-table-design helps agents design or review PostgreSQL schemas with practical rules for keys, normalization, data types, constraints, foreign key indexes, and PostgreSQL-specific gotchas.

Database Engineering
Favorites 0GitHub 32.6k
W
temporal-python-testing

by wshobson

temporal-python-testing helps teams test Temporal Python workflows with pytest, time-skipping, mocked-activity integration tests, replay testing, and local setup guidance for reliable workflow changes and CI.

Test Automation
Favorites 0GitHub 32.6k
W
database-migration

by wshobson

database-migration helps plan and generate schema and data migrations across ORM and SQL workflows, with rollback safety, phased rollouts, and zero-downtime guidance for production Database Engineering teams.

Database Engineering
Favorites 0GitHub 32.5k
P
sql-queries

by phuryn

The sql-queries skill turns business questions and rough analytics goals into optimized SQL for BigQuery, PostgreSQL, MySQL, and other dialects. It reads schema context, clarifies filters and aggregations, and helps with sql-queries for Data Analysis, reporting, and exploration.

Data Analysis
Favorites 0GitHub 11k
M
azure-postgres-ts

by microsoft

azure-postgres-ts helps Node.js and TypeScript apps connect to Azure Database for PostgreSQL Flexible Server with pg. Use it for backend services, API routes, workers, pooling, transactions, and password or Microsoft Entra ID auth. This azure-postgres-ts skill is a practical azure-postgres-ts guide for backend development.

Backend Development
Favorites 0GitHub 2.3k
M
azure-resource-manager-postgresql-dotnet

by microsoft

azure-resource-manager-postgresql-dotnet helps .NET engineers manage Azure Database for PostgreSQL Flexible Server with Azure Resource Manager. Use it to install the Azure.ResourceManager.PostgreSql and Azure.Identity packages, then create, update, inspect, secure, and automate PostgreSQL servers in Azure with clearer scope than a generic prompt.

Database Engineering
Favorites 0GitHub 2.2k
S
supabase-postgres-best-practices

by supabase

supabase-postgres-best-practices is a Supabase Postgres optimization skill for query tuning, indexing, schema design, RLS performance, locking, and connection management.

Database Engineering
Favorites 0GitHub 1.7k
A
medusa

by alinaqi

The medusa skill helps you set up and extend Medusa for Backend Development. Use it for a headless commerce backend, admin tooling, modules, API routes, and practical medusa guide steps for install, setup, and usage with Node.js and PostgreSQL.

Backend Development
Favorites 0GitHub 607
A
database-schema

by alinaqi

database-schema helps agents read the database contract before writing queries, migrations, or model code. It reduces wrong column names, missing fields, and type mismatches by checking schema files and generated types first. Use this database-schema guide for safer Database Engineering workflows.

Database Engineering
Favorites 0GitHub 607
J
postgres-nio

by Joannis

The postgres-nio skill helps you use PostgreSQL from Swift with async/await, connection pooling, prepared statements, and type-safe queries. It is a strong fit for Backend Development teams building Swift services that need practical postgres-nio usage, not generic SQL theory.

Backend Development
Favorites 0GitHub 57
N
neon-postgres-egress-optimizer

by neondatabase

neon-postgres-egress-optimizer helps diagnose and reduce Postgres egress by using pg_stat_statements to find overfetching queries, validate measurement windows, and guide app-side fixes such as narrower selects, pagination, and ORM query changes.

Database Engineering
Favorites 0GitHub 43
N
claimable-postgres

by neondatabase

claimable-postgres helps you provision a temporary Neon Postgres database fast with no signup. Use REST API, CLI, SDK, or Vite plugin to get a DATABASE_URL for local development, demos, tests, and short-lived review environments. Databases expire after 72 hours unless claimed.

Database Engineering
Favorites 0GitHub 43
N
neon-postgres

by neondatabase

The neon-postgres skill helps agents answer Neon Serverless Postgres questions with less guesswork. Learn install context, usage patterns, connection choices, local development, branching, auth, the Data API, Neon CLI, and how to verify current Neon docs before acting.

Database Engineering
Favorites 0GitHub 43
J
database-driver-design

by Joannis

database-driver-design is a guide for designing production-quality Swift database client libraries. It covers wire protocols, connection management, type-safe command APIs, pooling, backpressure, and Swift Concurrency alignment for Backend Development teams.

Backend Development
Favorites 0GitHub 0
A
supabase-python

by alinaqi

The supabase-python skill helps you build a Python backend with FastAPI, Supabase Auth, and SQLAlchemy/SQLModel. It is a practical Supabase Python guide for backend development when you want Supabase for auth, storage, and realtime, while keeping type-safe database access in Python.

Backend Development
Favorites 0GitHub 0
A
supabase-nextjs

by alinaqi

supabase-nextjs helps build Next.js App Router apps with Supabase auth, storage, and realtime, while using Drizzle ORM for typed database queries. It fits backend development workflows that need protected routes, server-side session handling, and a clear server/client split.

Backend Development
Favorites 0GitHub 0
Postgres tagged agent skills