Skip to content
J·BJon BishopFractional growth marketer

Data platforms · llms.txt file breakdown

MariaDB llms.txt

A directly retrieved Markdown index for MariaDB's documentation, with 9035 links across 12 detected headings.

The actual file

Source Markdown

The saved llms.txt text, displayed as source. The file belongs to its publisher; the live endpoint may change.

Open saved text ↗

Showing the first 18000 characters. Load the complete file to read the remainder.

# MariaDB Documentation

## Home

- [MariaDB Documentation](https://mariadb.com/docs/readme.md): Comprehensive documentation, release notes and learning resources for all MariaDB products.
- [MariaDB Server Ecosystem Hub](https://mariadb.com/docs/mariadb-server-ecosystem-hub.md): A curated discovery platform for the tools, services, platforms, and partners that work with MariaDB Server.

## MariaDB Platform

- [MariaDB Enterprise Platform](https://mariadb.com/docs/platform/readme.md)
- [Install a MariaDB Enterprise License](https://mariadb.com/docs/platform/enterprise-license-install.md): Where to get a MariaDB license and how to install it, for every MariaDB product that requires one. Start here, then follow the link for your product.
- [MariaDB Platform Use Cases](https://mariadb.com/docs/platform/mariadb-platform-use-cases.md)
- [MariaDB Platform Quickstart Guides](https://mariadb.com/docs/platform/mariadb-platform-quickstart-guides.md)
- [MariaDB Overview](https://mariadb.com/docs/platform/mariadb-platform-quickstart-guides/mariadb-overview-guide.md)
- [Best Practices](https://mariadb.com/docs/platform/mariadb-platform-quickstart-guides/mariadb-best-practices-guide.md)
- [Security](https://mariadb.com/docs/platform/mariadb-platform-quickstart-guides/security.md)
- [Style](https://mariadb.com/docs/platform/style.md)
- [MariaDB FAQs](https://mariadb.com/docs/platform/mariadb-faqs.md): MariaDB Frequently Asked Questions
- [Database Servers](https://mariadb.com/docs/platform/mariadb-faqs/database-servers.md)
- [MariaDB Enterprise Server](https://mariadb.com/docs/platform/mariadb-faqs/database-servers/mariadb-enterprise-server.md)
- [High Availability & Clustering Solutions](https://mariadb.com/docs/platform/mariadb-faqs/high-availability-and-clustering-solutions.md)
- [MariaDB Enterprise Cluster (powered by Galera Cluster)](https://mariadb.com/docs/platform/mariadb-faqs/high-availability-and-clustering-solutions/mariadb-enterprise-cluster-powered-by-galera-cluster.md)
- [Analytical Solutions](https://mariadb.com/docs/platform/mariadb-faqs/analytical-solutions.md)
- [MariaDB ColumnStore](https://mariadb.com/docs/platform/mariadb-faqs/analytical-solutions/mariadb-columnstore.md)
- [Database Proxies & Routers](https://mariadb.com/docs/platform/mariadb-faqs/database-proxies-and-routers.md)
- [MariaDB MaxScale](https://mariadb.com/docs/platform/mariadb-faqs/database-proxies-and-routers/mariadb-maxscale.md)
- [Management & Operations Tools](https://mariadb.com/docs/platform/mariadb-faqs/management-and-operations-tools.md)
- [MariaDB Connectors](https://mariadb.com/docs/platform/mariadb-faqs/management-and-operations-tools/mariadb-connectors.md)
- [MariaDB Kubernetes Operator](https://mariadb.com/docs/platform/mariadb-faqs/management-and-operations-tools/mariadb-kubernetes-operator.md)
- [MariaDB Enterprise Backup](https://mariadb.com/docs/platform/mariadb-faqs/management-and-operations-tools/mariadb-enterprise-backup.md)
- [Storage Engines](https://mariadb.com/docs/platform/mariadb-faqs/storage-engines.md)
- [InnoDB Storage Engine](https://mariadb.com/docs/platform/mariadb-faqs/storage-engines/innodb-storage-engine.md)
- [Aria Storage Engine](https://mariadb.com/docs/platform/mariadb-faqs/storage-engines/aria-storage-engine.md)
- [MyRocks Storage Engine](https://mariadb.com/docs/platform/mariadb-faqs/storage-engines/myrocks-storage-engine.md)
- [Spider Storage Engine](https://mariadb.com/docs/platform/mariadb-faqs/storage-engines/spider-storage-engine.md)
- [Plugins](https://mariadb.com/docs/platform/mariadb-faqs/plugins.md)
- [MariaDB Enterprise Audit Plugin](https://mariadb.com/docs/platform/mariadb-faqs/plugins/mariadb-enterprise-audit-plugin.md)
- [MariaDB HashiCorp Vault Plugin](https://mariadb.com/docs/platform/mariadb-faqs/plugins/mariadb-hashicorp-vault-plugin.md)
- [MariaDB Enterprise Platform](https://mariadb.com/docs/platform/mariadb-faqs/mariadb-enterprise-platform.md)

## Server

- [MariaDB Server Documentation](https://mariadb.com/docs/server/readme.md): Explore MariaDB Server, the powerful open-source relational database. This comprehensive documentation covers installation, deployment, usage, security, and advanced topics to help you master MariaDB.
- [Quickstart Guides](https://mariadb.com/docs/server/mariadb-quickstart-guides.md): Get started quickly with MariaDB Server using these quickstart guides. Follow step-by-step instructions to install, configure, and begin using MariaDB for your projects.
- [Installing MariaDB Server Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/installing-mariadb-server-guide.md): Official MariaDB Server install guide: Linux apt/dnf/yum commands, mariadb-secure-installation setup, systemctl status/start checks, Windows .msi installer.
- [Adding & Changing Data Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-adding-and-changing-data-guide-1.md): This guide provides a walkthrough of the INSERT, UPDATE, and DELETE statements, demonstrating how to add, modify, and remove data in tables.
- [Essential Queries Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-advanced-sql-guide.md): Learn how to perform essential SQL operations such as creating tables, inserting data, and using aggregate functions like MAX, MIN, and AVG.
- [Basics Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/basics-guide.md): Complete MariaDB basics guide: connect with mariadb -u/-p/-h, CREATE DATABASE/USE, CREATE TABLE with AUTO\_INCREMENT, INSERT/SELECT/UPDATE/DELETE commands.
- [Altering Tables Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-alter-table-guide-1.md): Learn how to modify existing table structures using the ALTER TABLE statement, including adding columns, changing types, and managing indexes.
- [Connecting to MariaDB Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-connecting-guide.md): This guide details how to connect to a MariaDB server using the command-line client, covering options for host, user, password, and protocol.
- [Troubleshooting Connection Issues Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-connection-troubleshooting-guide.md): Diagnose and fix common MariaDB Server connection problems, such as "Can't connect to local server" and access-denied errors, with step-by-step troubleshooting.
- [Doing Time Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-datetime-guide.md): Understand how to work with date and time values in MariaDB, including data types like DATETIME and TIMESTAMP, and useful temporal functions.
- [Importing Data Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-importing-data-guide.md): Learn how to efficiently import data into MariaDB tables from external files using the LOAD DATA INFILE statement.
- [Essentials of an Index Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/essentials-of-an-index-guide.md): This guide provides a conceptual overview of database indexes, explaining their purpose, different types, and when to use them for optimization.
- [Getting Started with Indexes Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-indexes-guide.md): Definitive MariaDB indexes guide: PRIMARY KEY, UNIQUE INDEX, INDEX, FULLTEXT types, CREATE/ALTER TABLE syntax, CREATE INDEX, SHOW INDEX, and EXPLAIN.
- [Joining Tables with JOIN Clauses](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-join-guide.md): This guide introduces the different types of JOINs (INNER, LEFT, RIGHT, CROSS) and demonstrates how to combine data from multiple tables.
- [Advanced Joins](https://mariadb.com/docs/server/mariadb-quickstart-guides/more-advanced-joins.md): Explore complex join scenarios. This guide covers filtering joined data with WHERE clauses, handling dates, and aggregating results from multiple tables for deeper analysis.
- [Configuring MariaDB for Remote Client Access Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-remote-connection-guide.md): Configure MariaDB Server to accept remote connections by setting bind-address, granting privileges for remote users, and opening the right firewall rules.
- [Getting Data Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-selecting-data-guide.md): This guide explains the SELECT statement in detail, covering how to retrieve, filter, limit, and sort data from your MariaDB database.
- [Basic SQL Statements Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-sql-cheat-cheat-guide.md): A quick reference for core SQL statements including DDL (CREATE, DROP), DML (INSERT, UPDATE, DELETE), and TCL (COMMIT, ROLLBACK) commands.
- [Basic SQL Debugging Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-sql-debugging-guide.md): This guide offers conventions and practical tips for designing SQL queries that are easier to read, understand, and debug.
- [MariaDB String Functions Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-string-functions-guide.md): This guide goes through several built-in string functions in MariaDB, grouping them by similar features, and providing examples of how they might be used.
- [Restoring Data from Dump Files Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-restore-guide.md): Restore MariaDB data from mariadb-dump backup files using the mariadb client, including how to selectively restore a single table.
- [Changing Times in MariaDB](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-time-guide.md): This guide explores MariaDB functions for performing calculations and modifications on date and time values, like DATE\_ADD and DATE\_SUB.
- [System & Status Variables Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/system-and-status-variables-guide.md): This guide indicates where the various system and status variables of MariaDB Server are found.
- [Making Backups with mariadb-dump Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-backup-guide.md): Create logical backups of MariaDB databases with the mariadb-dump utility, covering how to back up all databases, specific databases, or individual tables.
- [A MariaDB Primer Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-usage-guide.md): A beginner-friendly primer on using the mariadb command-line client to log in, create databases, and execute basic SQL commands.
- [Creating & Using Views Guide](https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-views-guide.md): Discover how to create and use views to simplify complex queries, restrict data access, and present a specific perspective of your data.
- [Database Applications](https://mariadb.com/docs/server/mariadb-quickstart-guides/database-applications.md): This section offers advice on writing and maintaining applications that use databases, covering schema design, code practices, and testing.
- [Introduction & Background](https://mariadb.com/docs/server/mariadb-quickstart-guides/database-applications/introduction-and-background.md): This section provides an introduction to developing database-backed applications with MariaDB, discussing maintenance, upgrades, and separation of concerns.
- [Database Design](https://mariadb.com/docs/server/mariadb-quickstart-guides/database-applications/database-design.md): Learn about best practices for database schema design, including naming conventions, choosing appropriate data types, and using views to abstract complexity.
- [Application Code](https://mariadb.com/docs/server/mariadb-quickstart-guides/database-applications/application-code.md): This guide covers application-side considerations, such as using ORMs, stored procedures, and writing robust SQL that handles schema changes gracefully.
- [Canary Testing](https://mariadb.com/docs/server/mariadb-quickstart-guides/database-applications/canary-testing.md): Explore strategies for safely testing schema and application changes using canary deployments, replication, and features like invisible columns.
- [Server Usage](https://mariadb.com/docs/server/server-usage.md): Learn how to effectively use MariaDB Server. This section covers SQL statements, built-in functions, client utilities, and best practices for daily database operations.
- [Basics](https://mariadb.com/docs/server/server-usage/basics.md): Grasp the basics of using MariaDB Server. This section introduces fundamental concepts, common SQL commands, and essential operations to get you started with your database.
- [Basic Queries](https://mariadb.com/docs/server/server-usage/basics/mariadb-advanced-usage-guide-1.md): This guide covers the fundamentals of creating database structures, inserting data, and retrieving information using the default MariaDB client.
- [Backup & Restore](https://mariadb.com/docs/server/server-usage/backup-and-restore.md): Learn to back up and restore MariaDB Server databases. This section covers essential strategies and tools to ensure data safety and quick recovery from potential data loss.
- [Backup and Restore Overview](https://mariadb.com/docs/server/server-usage/backup-and-restore/backup-and-restore-overview.md): Complete MariaDB backup and recovery guide. Complete resource for backup methods, mariabackup usage, scheduling, and restoration for production use.
- [Forming a Backup Strategy](https://mariadb.com/docs/server/server-usage/backup-and-restore/forming-a-backup-strategy.md): Learn how to design a robust backup strategy tailored to your business needs, balancing recovery time objectives and data retention policies.
- [Backup Optimization](https://mariadb.com/docs/server/server-usage/backup-and-restore/backup-optimization.md): Discover techniques to optimize your backup processes, including multithreading, incremental backups, and leveraging storage snapshots.
- [MariaDB Enterprise Backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-enterprise-backup.md): This page details MariaDB Enterprise Backup, an enhanced version of mariadb-backup with enterprise-specific optimizations and support.
- [mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup.md): Get an overview of MariaDB Backup. This section introduces the hot physical backup tool, explaining its capabilities for efficient and consistent backups of your MariaDB Server.
- [mariadb-backup Overview](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-overview.md): Complete MariaDB backup and recovery guide. Complete resource for backup methods, mariadb-backup usage, scheduling, and restoration for production use.
- [mariadb-backup Options](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-options.md): Reference for mariadb-backup (mariabackup) command-line options. Covers --backup, --prepare, --copy-back, --move-back, streaming, and incremental backups.
- [Full Backup and Restore (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/full-backup-and-restore-with-mariadb-backup.md): Complete MariaDB backup and recovery guide. Complete resource for backup methods, mariabackup usage, scheduling, and restoration for production use.
- [Incremental Backup and Restore (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/incremental-backup-and-restore-with-mariadb-backup.md): Complete mariadb-backup incremental guide: --backup/--prepare syntax, LSN mariadb\_backup\_checkpoints, --incremental-basedir, and --copy-back/--move-back restore.
- [Partial Backup and Restore (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/partial-backup-and-restore-with-mariadb-backup.md): Back up specific databases or tables. This guide explains how to filter your backup to include only the data you need.
- [Point-In-Time Recovery (PITR, mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/point-in-time-recovery-pitr-mariadb-backup.md): Explains how to restore (recover) to a specific point in time. Point-in-time recovery is often referred to as PITR.
- [Restoring Individual Databases From a Full Backup (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/individual-database-restores-with-mariadb-backup-from-full-backup.md): Restore a single database from a full backup. Learn the procedure to extract and recover a specific database schema from a larger backup set.
- [Restoring Individual Tables and Partitions (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/restoring-individual-tables-and-partitions-with-mariadb-backup.md): Restore specific tables from a backup. Learn the process of importing individual .ibd files to recover specific tables without restoring the whole database.
- [Setting up a Replica (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/setting-up-a-replica-with-mariadb-backup.md): Initialize a replication slave using a backup. This guide shows how to use mariadb-backup to provision a new replica from a master server.
- [Files Backed Up by mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/files-backed-up-by-mariadb-backup.md): List of file types included in a backup. Understand which data files, logs, and configuration files are preserved during the backup process.
- [Files Created by mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/files-created-by-mariadb-backup.md): Reference of files generated during backup. This page explains the purpose of metadata files like xtrabackup\_checkpoints created by the tool.
- [Using Encryption 

Measured from the saved file

Linked document

UTF-8 text size
1.9 MB2040925 bytes
Token count
537233o200k_base encoding
Markdown links
91629162 distinct URLs
Fenced code blocks
09200 lines in the file

Size measures the captured UTF-8 text, not compressed transfer size. Tokens are counted with a named tokenizer; other models can count differently. Neither measure establishes context compatibility or answer quality.

Project H1
MariaDB Documentation

Context architecture

How the content is divided

11 H2 sections organize 9162 parsed Markdown links. 9162 links point to .md or .markdown paths; 0 link occurrences use another hostname. Linked destinations have not been recursively validated.

H2 sectionLinksUTF-8 bytesTokens
HomeLine 3235880
MariaDB PlatformLine 8303538925
ServerLine 414192994954234478
MaxScaleLine 424051511989432394
AnalyticsLine 47581715219711741
Galera ClusterLine 4932100316377517
ConnectorsLine 50353479560522748
ToolsLine 53853518820919199
MariaDB CloudLine 5739134349087756
Release NotesLine 58763200601505196189
General ResourcesLine 9079120179364169

Link counts exclude parsed fenced and inline code and resolve relative destinations against the final endpoint. Section sizes cover the text below each H2 until the next H2.

Embedded material

Code, installation and API examples

Fenced blocks
0 closed
Declared languages
No fenced blocks detected
Package-install commands
0 detected in fenced or inline code
Authentication examples
0 fenced lines match API-key, Authorization, Bearer, OAuth or access-token patterns
HTTP request examples
0 fenced lines match request-method patterns
Authentication links
7 links have authentication-related labels

Embedded example text and links to further documentation are counted separately. A code block does not establish that a sample runs or that an authentication flow succeeds.

Publisher prioritization

The Optional section

No H2 section named “Optional” was detected in this file.

The community proposal uses Optional by convention for secondary links that can be skipped for a shorter context. This label does not establish that everything outside it is critical, or that the material inside it is deprecated.

Machine-readable routes

MCP references and configuration text

MCP-related text was detected in the captured file. 34 links have MCP-related labels or paths. 0 fenced lines match mcpServers, mcp_servers or an mcp add command.

These are text and link observations. No MCP server connection, authentication or tool call was tested.

Index and bundle

llms-full.txt companion

Verified text companion

Text companion verified

https://mariadb.com/docs/llms-full.txt ↗
Discovery
Conventional sibling path checked
HTTP response
206 · text/markdown; charset=utf-8
Text size
765.1 KB · 783483 bytes (server-reported)
Token count
185267 o200k_base tokens
Retrieval scope
Complete body retrieved

A verified text response establishes a companion at the checked URL. It does not prove the bundle contains all product documentation, that generation is automated, or that it fits an assistant’s context window.

Change evidence

What can be said about freshness

This capture establishes a baseline. Update frequency cannot be determined from one observation.

Linked release and migration material

3313 links have release, changelog, deprecation or migration terms in their labels or paths. These provide places to investigate product changes separately.

File changes can reveal documentation edits or navigation changes. They do not by themselves measure product release velocity, accuracy, agent adoption or AI visibility.

Capture identity and measurement method
Requested endpoint
https://mariadb.com/docs/llms.txt
Final endpoint
https://mariadb.com/docs/llms.txt
HTTP status
200
Content type
text/markdown; charset=utf-8
Text retrieval
Firecrawl literal text capture
Tokenizer
tiktoken 0.14.0 · o200k_base
SHA-256 of saved UTF-8 text
0f805b95c391edfa132a68c109455de1c9c9b61c72a370e0f1f5a3af530d1663

Counts use a deterministic parser, not a spec-compliance grade. Unusual Markdown and indented code can fall outside its recognized patterns. See the llms.txt proposal and tokenizer implementation.

Related tools and resources

Contact Jon