fidpa

Psql AI Assisted Development — AI skill for Claude Code

AI community

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.

How to install Psql AI Assisted Development

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

What Psql AI Assisted Development does

Alternatives in AI

Fine Tuning — ai-research-skills Axolotl, LLaMA-Factory, PEFT, Unsloth 5.4k ★
HarnessKit — More than a skill manager — manage skills, MCP servers, plugins, hooks, CLIs, configs, memory & rules across e 416 ★
Module Feature — Add a new feature (model + service + controller + views + routes + tests) to an existing module 407 ★

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