Skills
.Work. You
Rest

MySQL Database

Community

Conecte, otimize e migre MySQL com Lazarus/Zeos

Software Engineering#migrations#mysql#database-patterns#mariadb#lazarus#sqldb#zeos
Authordelphicleancode
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill consolidates best practices for developing with MySQL and MariaDB in FreePascal/Lazarus using SQLdb/Zeos, covering connection setup, data typing, JSON usage, triggers, stored procedures, replication, and migration scripting.

Core Features & Use Cases

  • Connection management: reliable SQLdb/Zeos connections to MySQL/MariaDB servers with sane defaults.
  • Data mapping: mapping MySQL types to FreePascal types (ftInteger, ftString, ftJSON, etc) and practical code patterns.
  • Advanced features: JSON storage, triggers, procedures, functions, and upsert patterns (ON DUPLICATE KEY UPDATE).
  • Migrations & DevOps: schema migrations and versioned scripts for repeatable deployments, including InnoDB defaults and UTF8MB4 usage.
  • Guidance & examples: templates and examples for repositories, transactions, error handling and basic security practices.

Quick Start

Configure the MySQL connection via SQLdb/Zeos and create a simple table to validate end-to-end integration.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: MySQL Database
Download link: https://github.com/delphicleancode/lazarus-spec-kit/archive/main.zip#mysql-database

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.