| name | phpmyadmin-mcp-connector |
| description | MCP connector for phpMyAdmin MySQL administration – enables AI-powered MySQL management, query building, and database operations through Claude |
| license | GPL |
| tags | ["data","mysql","mcp","phpmyadmin","database"] |
| difficulty | beginner |
| time_to_master | 4-8 weeks |
| version | 1.0.0 |
Phpmyadmin MCP Connector
Overview
This skill enables Claude to interact with Phpmyadmin through the Model Context Protocol (MCP). It provides a bridge between Claude's AI capabilities and Phpmyadmin's HTTP/API, allowing natural language control of Phpmyadmin operations, intelligent automation, and AI-powered assistance for Phpmyadmin workflows.
When to Use This Skill
- MySQL query generation and execution
- Table design and relationship management
- Import/export and backup operations
- User and privilege management
- Database optimization and repair
Architecture
┌─────────────┐ ┌─────────────────┐ ┌──────────────────┐
│ Claude │────▶│ MCP Server │────▶│ Phpmyadmin │
│ (Client) │◀────│ (TypeScript) │◀────│ (HTTP/API )│
└─────────────┘ └─────────────────┘ └──────────────────┘
Core Concepts
MCP Server Setup
The connector implements an MCP server that exposes Phpmyadmin operations as tools Claude can invoke. The server translates natural language intentions into HTTP/API calls.
Key Endpoints/Interfaces
sql.php, tbl_create.php, db_export.php, server_privileges.php, db_operations.php
Implementation
import { McpServer } from "@modelcontextprotocol/sdk/server/mcp.js";
import { StdioServerTransport } from "@modelcontextprotocol/sdk/server/stdio.js";
import { z } from "zod";
const server = new McpServer({
name: "phpmyadmin-mcp-connector",
version: "1.0.0",
});
server.tool(
"list_resources",
"List and query Phpmyadmin resources with optional filters",
{
query: z.string().optional().describe("Search query or filter"),
limit: z.number().optional().describe("Max results to return"),
},
async ({ query, limit }) => {
const response = await fetch(`${BASE_URL}sql.php`, {
headers: { "Authorization": `Bearer ${API_KEY}` },
});
const data = await response.json();
return {
: [{ : , : .(data, , ) }],
};
}
);
server.(
,
,
{
: z.().(),
: z.({}).().().(),
},
({ name, config }) => {
response = (, {
: ,
: {
: ,
: ,
},
: .({ name, ...config }),
});
data = response.();
{
: [{ : , : }],
};
}
);
server.(
,
,
{
: z.().(),
: z.().().(),
},
({ , timeframe }) => {
response = (, {
: { : },
});
data = response.();
{
: [{ : , : .(data, , ) }],
};
}
);
transport = ();
server.(transport);
Claude Desktop Configuration
{
"mcpServers": {
"phpmyadmin-mcp-connector": {
"command": "node",
"args": ["path/to/phpmyadmin-mcp-connector/index.js"],
"env": {
"PHPMYADMIN_API_KEY": "your-api-key",
"PHPMYADMIN_BASE_URL": "https://your-instance-url"
}
}
}
}
Best Practices
- Authentication: Store API keys securely using environment variables; never hardcode credentials
- Rate Limiting: Implement request throttling to respect Phpmyadmin API rate limits
- Error Handling: Provide clear, actionable error messages for common failure scenarios
- Pagination: Handle paginated responses for large datasets efficiently
- Caching: Cache frequently accessed read-only data to reduce API calls
- Security: Validate all inputs before passing to the Phpmyadmin API; sanitize outputs
- Logging: Log all API interactions for debugging and audit purposes
Example Prompts
"Create a normalized database schema for an e-commerce application with proper foreign keys"
Security Considerations
- All API credentials must be stored as environment variables
- Implement input validation and sanitization for all tool parameters
- Use HTTPS for all API communications
- Follow the principle of least privilege for API token permissions
- Audit log all write operations for compliance tracking
Resources
Changelog
| Version | Date | Changes |
|---|
| 1.0.0 | 2026-04-01 | Initial MCP connector skill |
Part of SkillGalaxy - 10,000+ comprehensive skills for AI-assisted development.
