Connect Mysql to AI agents

Connect Mysql to Claude, Codex, Cursor, or other AI agents for your entire team. Metorial security, governance, observability, and gives your team a unified Magic MCP url to connect.

Deploy MysqlBook a demo

Supported Tools

Tools11Triggers2

update_rows

Update Rows

Update rows in a MySQL table that match a WHERE condition. Provide the columns to update as key-value pairs. Requires a WHERE clause to target specific rows unless confirmUpdateAll is explicitly set.

manage_table

Manage Table

Create, alter, or drop a MySQL table. Supports creating tables with columns, constraints, foreign keys, and storage engine selection. For altering tables, supports adding columns, dropping columns, renaming columns, modifying column types, and renaming the table.

insert_rows

Insert Rows

Insert one or more rows into a MySQL table. Provide the data as an array of objects where keys are column names and values are the data to insert. Supports inserting multiple rows in a single operation and handling duplicate key conflicts.

manage_indexes

Manage Indexes

Create or drop indexes on MySQL tables. Supports standard, unique, fulltext, and spatial indexes. Useful for optimizing query performance by adding appropriate indexes.

execute_query

Execute SQL Query

Execute an arbitrary SQL query against the MySQL database. Supports all SQL operations including SELECT, INSERT, UPDATE, DELETE, and DDL statements (CREATE, ALTER, DROP). Returns column metadata and result rows for SELECT queries, or affected row counts for DML/DDL statements. Supports complex queries with joins, subqueries, CTEs, window functions, and aggregations.

manage_users

Manage Users

Create, drop, or manage MySQL user accounts and their privileges. Supports granting and revoking permissions at the global, database, table, or column level. Can also list existing users and their grants.

delete_rows

Delete Rows

Delete rows from a MySQL table that match a WHERE condition. Requires a WHERE clause to target specific rows unless confirmDeleteAll is explicitly set.

list_tables

List Tables

List all tables in a MySQL database. Returns table names, types, engines, row estimates, and size information. Also supports listing views.

describe_table

Describe Table

Get detailed schema information for a specific MySQL table, including columns, data types, constraints, indexes, and foreign keys. Useful for understanding table structure before building queries or modifying schemas.

list_databases

List Databases

List all databases on the MySQL server. Returns database names, default character sets, and collations. Optionally includes system databases (information_schema, performance_schema, mysql, sys).

manage_database

Manage Database

Create or drop MySQL databases. Supports IF NOT EXISTS for creation, IF EXISTS for drops, and optional default character set and collation settings.

More integrations teams use with Mysql

GitHub

Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Subscribe to webhooks for list and library change notifications. Retrieve site properties and search for sites across Microsoft 365.

Salesforce

Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Subscribe to real-time change events via Change Data Capture and Platform Events. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

Airtable

Create, read, update, and delete records in Airtable bases and tables. Manage base schemas including creating tables and fields. Filter records using formulas, sort by fields, and scope queries to specific views. Upsert records to find, create, or update in a single call. Upload attachments to records, read and write record comments, list accessible bases, and receive real-time base change events through webhooks.

Bitbucket

Manage Git repositories, pull requests, and CI/CD pipelines on Bitbucket Cloud. Create, fork, and configure repositories within workspaces and projects. Create, review, approve, merge, and decline pull requests with inline code comments. Browse source code, list commits, and manage branches and tags. Track issues with the built-in issue tracker. Trigger, monitor, and manage Bitbucket Pipelines. List workspace members, configure repository default reviewers and branch restrictions, create and manage repository webhooks, and search code across repositories.

Heroku

Deploy, manage, and scale applications on Heroku's cloud platform. Create and configure apps, scale dynos, provision add-ons (databases, caching, etc.), manage configuration variables, build and release code, add custom domains and SSL certificates, manage collaborators and team permissions, configure pipelines for continuous delivery, set up log drains, and sync data with Salesforce via Heroku Connect. Subscribe to webhooks for real-time notifications on app changes, builds, releases, dyno lifecycle events, and more.

Technical notes for Mysql

Execute SQL queries to read, insert, update, and delete data in MySQL databases. Create and manage databases, tables, indexes, views, and other schema objects. Inspect schema metadata including columns, constraints, and indexes via INFORMATION_SCHEMA. Run stored procedures and user-defined functions. Manage user accounts and privileges. Execute transactions with ACID compliance. Bulk import and export data in CSV and delimited formats. Stream real-time data change events (inserts, updates, deletes, schema changes) via binary log (binlog) replication for change data capture (CDC).

Connect Mysql to production AI agents

See how Metorial gives Mysql access the governance, tracing, and security controls teams need.

Book a demoDeploy Mysql

Frequently asked questions

Common questions about connecting Mysql to AI agents with Metorial.

  1. Can Metorial connect Mysql to AI agents?
    Yes. Metorial connects AI agents to Mysql through a governed integration layer, so teams can use the provider while keeping access controlled and observable.
  2. Metorial is MCP compatible and lets teams expose approved provider tools to MCP-capable agents and clients through a controlled access layer.
  3. Metorial applies policies across users, groups, providers, agents, and individual tools, then records the context around every agent interaction.
  4. Yes. Metorial records provider activity so teams can inspect tool calls, troubleshoot integrations, and give security teams the visibility they need.