skills.rest
delphicleancode
delphicleancodeCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/delphicleancode/lazarus-spec-kit --skill postgresql-database
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
delphicleancodedelphicleancode
17

MySQL Database

Configure MySQL/MariaDB connections and data mappings in FreePascal/Lazarus with SQLdb/Zeos.

Community
Advanced
anicdhanicdh

go-db

Configure pgx connection pools, queries, migrations, and transactions in Go.

Community
Advanced
delphicleancodedelphicleancode
17

FreePascal/Lazarus Code Review

Evaluate FreePascal/Lazarus code against correctness, security, performance, and style guidelines.

Community
Advanced
Impertio-StudioImpertio-Studio

postgres-errors-statement-timeouts

Manages PostgreSQL statement, lock, and transaction timeouts for web apps and batch processing.

Official
Advanced