Databases Basic Auth

MySQL REST API

Popular open-source relational database management system

MySQL is the world's most popular open-source relational database management system. Developers use it to store, organize, and retrieve structured data efficiently with ACID compliance, powerful query capabilities, and robust transaction support. MySQL powers millions of applications from small startups to enterprise-scale systems.

Base URL https://api.mysql.rest/v1

API Endpoints

Method	Endpoint	Description
POST	`/databases`	Create a new database instance
GET	`/databases`	List all database instances
GET	`/databases/{database_id}`	Get details of a specific database
DELETE	`/databases/{database_id}`	Delete a database instance
POST	`/databases/{database_id}/query`	Execute a SQL query on the database
GET	`/databases/{database_id}/tables`	List all tables in a database
POST	`/databases/{database_id}/tables`	Create a new table in the database
GET	`/databases/{database_id}/tables/{table_name}`	Get schema and metadata for a specific table
POST	`/databases/{database_id}/backup`	Create a backup of the database
GET	`/databases/{database_id}/backups`	List all backups for a database
POST	`/databases/{database_id}/restore`	Restore database from a backup
GET	`/databases/{database_id}/users`	List database users and their privileges
POST	`/databases/{database_id}/users`	Create a new database user with privileges
GET	`/databases/{database_id}/metrics`	Get performance metrics and statistics
POST	`/databases/{database_id}/replicas`	Create a read replica of the database

Code Examples

curl -X POST https://api.mysql.rest/v1/databases/db_123/query \
  -u 'username:password' \
  -H 'Content-Type: application/json' \
  -d '{
    "query": "SELECT * FROM users WHERE status = ? LIMIT ?",
    "params": ["active", 10]
  }'

const response = await fetch('https://api.mysql.rest/v1/databases/db_123/query', {
  method: 'POST',
  headers: {
    'Content-Type': 'application/json',
    'Authorization': 'Basic ' + btoa('username:password')
  },
  body: JSON.stringify({
    query: 'SELECT * FROM users WHERE status = ? LIMIT ?',
    params: ['active', 10]
  })
});

const data = await response.json();
console.log(data.rows);

import requests
from requests.auth import HTTPBasicAuth

response = requests.post(
    'https://api.mysql.rest/v1/databases/db_123/query',
    auth=HTTPBasicAuth('username', 'password'),
    json={
        'query': 'SELECT * FROM users WHERE status = %s LIMIT %s',
        'params': ['active', 10]
    }
)

data = response.json()
print(data['rows'])

Connect MySQL to AI

Deploy a MySQL MCP server on IOX Cloud and connect it to Claude, ChatGPT, Cursor, or any AI client. Your AI assistant gets direct access to MySQL through these tools:

mysql_query_executor Execute parameterized SQL queries safely with automatic connection management and result formatting

mysql_schema_analyzer Analyze database schema, generate ERD diagrams, and identify optimization opportunities

mysql_backup_manager Create, schedule, and restore database backups with automatic retention policies

mysql_performance_monitor Monitor query performance, identify slow queries, and suggest index improvements

mysql_migration_assistant Generate and execute database migrations, track schema versions, and rollback changes

Deploy in 60 seconds

Describe what you need, AI generates the code, and IOX deploys it globally.

Deploy MySQL MCP Server →

MySQL REST API

API Endpoints

Code Examples

Connect MySQL to AI

Deploy in 60 seconds

Related APIs