PostgreSQL Database

Configure PostgreSQL connections and map data types in FreePascal Lazarus projects.

17|7|Updated Mar 26, 2026

Search Tags:#database #postgresql #freepascal #lazarus #sqldb #zeos

Ready to run

npx skills add https://github.com/delphicleancode/lazarus-spec-kit --skill postgresql-database

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: PostgreSQL Database
Source: https://github.com/delphicleancode/lazarus-spec-kit/tree/main/.gemini/skills/postgresql-database
Command: npx skills add https://github.com/delphicleancode/lazarus-spec-kit --skill postgresql-database

SYSTEM DOCUMENTATION & REQUIREMENTS

## What problem does it solve? PostgreSQL is a powerful database, but integrating it with FreePascal Lazarus requires repetitive boilerplate code, error handling, and SQL mapping. This Skill provides structured guidance and reusable patterns to simplify connection setup, data mapping, common PostgreSQL features (JSONB, UPSERT, FTS), and migrations.

## Core Features & Use Cases

PostgreSQL connection setup with SQLdb/Zeos
Mapping PostgreSQL data types to FreePascal Lazarus types
Implementing UPSERT, JSONB, FTS, CTEs, and partitioning
Migration scripts and best practices for schema versioning
Use Case: configure a repository layer for a Lazarus app interfacing with PostgreSQL

Quick Start

Start with configuring your connection factory in your Lazarus project, initialize a TSQLConnection, and execute a parameterized query to fetch data.

Frequently Asked Questions about PostgreSQL Database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I set up a PostgreSQL connection in FreePascal Lazarus?▼

PostgreSQL connection setup in FreePascal Lazarus uses SQLdb or Zeos components to initialize a TSQLConnection and execute parameterized queries. The Skill provides structured guidance for configuring a connection factory and streamlining repetitive boilerplate code.

What's the best way to map PostgreSQL data types to FreePascal Lazarus types?▼

Mapping PostgreSQL data types to FreePascal Lazarus types is handled through structured guidance for data mapping. This covers standard types and advanced PostgreSQL features like JSONB, ensuring type safety across Lazarus applications.

Can I use UPSERT, JSONB, and full-text search with PostgreSQL in Lazarus?▼

UPSERT, JSONB, and full-text search are supported in Lazarus with PostgreSQL. The Skill provides reusable patterns for implementing these features, along with CTEs and partitioning, across Lazarus applications.

How do I manage database migrations and schema versioning in FreePascal Lazarus?▼

Database migrations and schema versioning in FreePascal Lazarus are managed through migration scripts and best practices. The Skill enforces migration-driven schema evolution to maintain database consistency.

Does this PostgreSQL Lazarus integration enforce parameterized queries and transaction handling?▼

Parameterized queries and explicit transaction handling are enforced by this PostgreSQL Lazarus integration. Error mapping translates database exceptions into helpful messages, ensuring safe and robust repository layer configuration.