Firebird Database

Implement Firebird database patterns in FreePascal/Lazarus with SQLdb/Zeos.

17|7|Updated Mar 26, 2026
One-click install
npx skills add https://github.com/delphicleancode/lazarus-spec-kit --skill firebird-database
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Firebird Database
Source: https://github.com/delphicleancode/lazarus-spec-kit/tree/main/.gemini/skills/firebird-database
Command: npx skills add https://github.com/delphicleancode/lazarus-spec-kit --skill firebird-database

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill provides the structured Firebird database development patterns for FreePascal/Lazarus using SQLdb/Zeos, covering connections, generators, transactions, migrations, and data-type mappings.

Core Features & Use Cases

  • Connection setup and driver configuration with SQLdb/Zeos for Firebird
  • Generator/Sequence usage, identity columns, and migrations
  • Transaction management, isolation levels, and schema evolution

Quick Start

Configure a Firebird connection with SQLdb/Zeos, enable Dialect 3 and UTF8, and start applying versioned migrations.

Frequently Asked Questions about Firebird Database

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

FAQPage Schema
How do I set up a Firebird database connection in FreePascal Lazarus?

You set up a Firebird database connection in FreePascal Lazarus by configuring SQLdb or Zeos components, enabling Dialect 3 and UTF-8 character set. This skill provides the structured patterns for establishing these connections and driver configurations.

What is the best way to manage Firebird generators and sequences in Lazarus?

The best way to manage Firebird generators and sequences in Lazarus is by applying structured database patterns for identity columns and migrations. This skill implements generator usage and schema versioning for FreePascal projects.

How do you handle Firebird database transactions and migrations in FreePascal?

Handling Firebird database transactions and migrations in FreePascal requires explicit transaction management with proper isolation levels. This skill provides patterns for schema evolution, versioned migrations, and transaction control.

Does this Firebird database skill support dialect 3 and UTF-8 character sets?

Yes, this Firebird database skill fully supports dialect 3 and UTF-8 character sets. It satisfies requirements for explicit transaction handling and schema versioning within FreePascal and Lazarus environments.

Can I use SQLdb and Zeos to map data types like domains and triggers in Firebird?

Yes, you can use SQLdb and Zeos to map data types like domains and triggers in Firebird. This skill implements robust database patterns covering data-type mappings and schema configurations for Lazarus projects.

Why do I need explicit transaction handling for Firebird databases in FreePascal?

You need explicit transaction handling for Firebird databases in FreePascal to ensure data integrity and manage isolation levels correctly. This skill provides transaction management patterns required for robust schema evolution.