MySQL Data Access Components (MyDAC)MySQL Data Access Components (MyDAC)

DevartData Access ToolsVCL Component
Version 14.0.1 (Jun 15, 2026)

Direct MySQL and MariaDB connectivity components for Delphi and C++Builder.

  • Build database applications using native MySQL and MariaDB connectivity.
  • Execute queries, scripts, and stored procedures from Delphi, C++Builder and Lazarus applications.
  • Manage datasets, metadata, and bulk data operations efficiently.
Devart logo

Prices from:

Loading...
Available individuallyOur Price
MySQL Data Access Components (MyDAC)Loading
Provide direct high performance access to MySQL.
MySQL Data Access Components (MyDAC) is a library for connecting Delphi, C++Builder, and Lazarus applications to MySQL and MariaDB. It provides native components for database connectivity, query execution, stored procedures, metadata retrieval, script execution, and dataset management, enabling developers to integrate MySQL data access directly into RAD Studio applications.

Direct Database Connectivity

MyDAC provides direct access to MySQL and MariaDB without requiring extra data access layers. It can also work through the MySQL client library, giving development teams flexibility in how they connect, deploy, and maintain database applications across different environments.

Stored Procedure And Function Support

MyDAC provides dedicated components for executing MySQL stored procedures and functions directly from Delphi applications. It supports input, output, and return parameters, enabling applications to integrate database side logic, reuse server functionality, and handle procedural operations through structured component interfaces.

Native Component Based Access

MyDAC includes native components for common database tasks such as connecting, querying, browsing tables, and calling stored procedures. This component based model fits naturally into Delphi style development and helps developers add database functionality directly inside their applications.

Flexible Query And SQL Handling

The library supports SQL execution through dedicated components for queries and statements, along with features such as automatic preparing, macros in SQL, and retrieval of output parameters. This gives developers practical control over everyday database operations and more advanced command handling.

Metadata And Server Information Access

MyDAC can retrieve metadata and server object information, which helps applications inspect database structure and available objects at runtime. This functionality is useful for administration features, dynamic forms, schema aware logic, and applications that need to adapt to database changes.

Local Dataset And Cached Updates

The library supports local data storage operations, cached updates, local sorting and filtering, and master detail relationships. These capabilities help applications manage data beyond a live connection, support offline style workflows, and control when changes are applied to the database.

Bulk Data And Data Exchange Features

MyDAC includes functionality for fast record insertion, batch data movement, dump and backup operations, and XML import or export. These features support applications that need to move, transfer, or process larger volumes of data as part of business workflows.

Script Execution Support

The library includes script execution capabilities for running individual statements and large scripts from files. It also supports multi statement execution and handling of standard MySQL client syntax, which is useful for setup routines, maintenance tasks, and database update scenarios.

Data Type Mapping And Compatibility

MyDAC provides data type mapping so developers can define how MySQL server data types correspond to Delphi data types. This helps when applications need more control over field handling, interoperability, and the way database values are represented inside code.

Performance Focused Data Access

The library is designed for lightweight, high performance database access. It includes optimized fetching, connection pooling, batch update handling, and other dataset level efficiencies that help applications work effectively with both routine operations and heavier database workloads.

Product Compatibility

Review the details below to ensure this product is supported within your environment.

Component Type

  • VCL Component

IDE Support

  • C++Builder
  • Delphi
  • RAD Studio