fidpa

Psql Ai Assisted Development

Name: Psql Ai Assisted Development
Author: fidpa

AI community

SOURCE https://github.com/fidpa/psql-ai-assisted-development

Description

Reference implementation for AI-assisted PostgreSQL development: star-schema KPI views, incremental materialised views, working-day arithmetic, 64 GB tuning config, and a CLAUDE.md workflow blueprint — extracted from a real SQL Server → PostgreSQL 16 production migration

Installation

This entry records only its repository, not the path inside it, so there is no exact command to give. Open the source below and copy the folder into ~/.claude/skills/, or the file into ~/.claude/agents/.

README

PostgreSQL AI-Assisted Development

[![CI](https://github.com/fidpa/psql-ai-assisted-development/actions/workflows/lint.yml/badge.svg)](https://github.com/fidpa/psql-ai-assisted-development/actions/workflows/lint.yml) [![License: MIT](https://img.shields.io/badge/License-MIT-green.svg)](LICENSE) [![Release](https://img.shields.io/github/v/release/fidpa/psql-ai-assisted-development)](https://github.com/fidpa/psql-ai-assisted-development/releases) ![PostgreSQL: 16+](https://img.shields.io/badge/PostgreSQL-16%2B-336791.svg?logo=postgresql&logoColor=white) ![Bash: 5+](https://img.shields.io/badge/Bash-5%2B-blue?logo=gnu-bash) [![Built with: Claude Code](https://img.shields.io/badge/Built%20with-Claude%20Code-d97757.svg)](https://www.claude.com/product/claude-code) [![Status](https://img.shields.io/badge/Status-Showcase-blue.svg)](#project-status) [![Last Commit](https://img.shields.io/github/last-commit/fidpa/psql-ai-assisted-development)](https://github.com/fidpa/psql-ai-assisted-development/commits/main)

A reference implementation for AI-assisted PostgreSQL development: star-schema KPI views, incremental materialised views, working-day arithmetic with movable holidays, a 64 GB tuning config, and a Claude Code workflow blueprint — extracted from a real production migration from SQL Server Express to PostgreSQL 16, fully documented in Diátaxis style.

**The Problem**: Most "AI-assisted development" content shows a chat transcript. This repository shows what a database codebase actually looks like *after* an AI assistant has been a real collaborator for months — not the prompts, but the artefacts. It is not a tutorial on how to prompt. It is a working snapshot of patterns, conventions, and guardrails that emerged from real iteration with Claude Code on a production migration from a 1 GB-RAM-bound SQL Server Express instance to PostgreSQL 16 on a 64 GB host.

The source domain has been replaced with a generic document-processing / order-tracking schema, and identifiers