PHP download

Download the PHP package momodemo333/php-mcp-mysql without Composer

On this page you can find all versions of the php package momodemo333/php-mcp-mysql. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download momodemo333/php-mcp-mysql
More information about momodemo333/php-mcp-mysql
Files in momodemo333/php-mcp-mysql

Vendor momodemo333
Package php-mcp-mysql
Short Description MySQL MCP Server for Claude Code - Secure and configurable MySQL integration via Model Context Protocol
License MIT
Homepage https://github.com/momodemo333/php-mcp-mysql

Keywords database mysql ai mcp model-context-protocol claude-code php-mcp

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.

Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
To use Composer is sometimes complicated. Especially for beginners.
Composer needs much resources. Sometimes they are not available on a simple webspace.
If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.

Please rate this library. Is it a good library?

Example code of momodemo333/php-mcp-mysql

Informations about the package php-mcp-mysql

🗄️ PHP MCP MySQL Server

MySQL MCP Server for Claude Code - Secure and configurable MySQL integration via Model Context Protocol.

🙏 Acknowledgments

This project is built on top of the excellent php-mcp/server library. Special thanks to the MCP community for providing the foundation that makes this integration possible.

🚀 Quick Installation

Via Composer (Recommended)

Claude Code Configuration

Add to your .cursor/mcp.json:

Quick Test

🎉 That's it! Your MySQL MCP Server is ready!

✨ Features

🛠️ Available MCP Tools

mysql_list_databases - List all databases
mysql_list_tables - List tables in a database
mysql_describe_table - Describe table structure (columns, indexes, foreign keys)
mysql_server_status - Get MySQL server status and health
mysql_select - Execute secure SELECT queries
mysql_insert - Insert data with validation
mysql_update - Update data with mandatory conditions
mysql_delete - Delete data with safety limits
mysql_execute_query - Execute custom SQL queries

🔒 Security Features

SQL Injection Protection - All queries use prepared statements
Operation Permissions - Granular control (INSERT, UPDATE, DELETE)
Query Validation - Dangerous keyword blocking
Connection Pooling - Efficient resource management
Result Limiting - Configurable result set limits
Schema Restrictions - Limit access to specific databases

⚙️ Configuration Options

Environment Variables:

MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB
ALLOW_INSERT_OPERATION, ALLOW_UPDATE_OPERATION, ALLOW_DELETE_OPERATION
ALLOW_DDL_OPERATIONS ⭐ - New! Authorize CREATE, ALTER, DROP operations
ALLOW_ALL_OPERATIONS ⭐ - New! Super admin mode (use with caution)
MAX_RESULTS, QUERY_TIMEOUT, LOG_LEVEL
CONNECTION_POOL_SIZE, ENABLE_PREPARED_STATEMENTS

Configuration Methods:

Environment Variables (via MCP config)
.env Files (per project)
CLI Arguments (for testing)

📖 Documentation

📚 Complete Guides

Quick Start - Get running in 5 minutes
MCP Configuration - Understanding MCP transports (stdio, http, websocket)
Installation Guide - Detailed setup instructions
MCP Tools Reference - Complete tool documentation
Usage Examples - Practical examples
Multi-Project Setup - Configure for multiple projects
Troubleshooting - Common issues and solutions

🔧 Configuration Examples

Simple Configuration:

💡 MCP Transport Types: The "type": "stdio" parameter specifies the communication method between your MCP client and the server. See MCP Configuration Guide for complete details on stdio, http, and websocket transports.

Multi-Environment Configuration:

🛡️ Security & Best Practices

🔐 Security Recommendations

Use Read-Only Users in Production
Limit Database Access
Set Result Limits
Use Environment Variables for Passwords

🔒 DDL Permissions (v1.1.0+)

Three-level permission system:

Level 1 - CRUD Operations:
Level 2 - Schema Operations (NEW!):
Level 3 - Super Admin (NEW!):

Example - Enable schema modifications:

✅ Production Checklist

[ ] Use dedicated MySQL user with minimal permissions
[ ] Set ALLOW_*_OPERATION=false for production (except SELECT)
[ ] Carefully consider ALLOW_DDL_OPERATIONS=false in production ⚠️
[ ] Never use ALLOW_ALL_OPERATIONS=true in production ❌
[ ] Configure MAX_RESULTS and QUERY_TIMEOUT
[ ] Use LOG_LEVEL=ERROR in production
[ ] Restrict ALLOWED_SCHEMAS to necessary databases
[ ] Store passwords securely (environment variables)
[ ] Enable BLOCK_DANGEROUS_KEYWORDS=true

🧪 Development & Testing

🚀 New Test Suite (v1.1.0+)

Professional testing infrastructure with Docker:

Test Coverage:

🧪 29+ tests (unit + integration)
🎯 >90% coverage of critical services
🐳 Automated Docker MySQL environment
🔄 CI/CD ready with GitHub Actions

Documentation:

📖 Complete Testing Guide
🚀 Quick Testing README

Legacy Testing

Development Setup

📊 Usage with Claude Code

Natural Language Examples

Database Exploration:

Data Analysis:

Business Intelligence:

Data Management:

🤝 Contributing

Contributions are welcome! Please read our contributing guidelines and:

Fork the repository
Create your feature branch: git checkout -b feature/amazing-feature
Commit your changes: git commit -m 'Add amazing feature'
Push to branch: git push origin feature/amazing-feature
Open a Pull Request

Development Guidelines

Follow PSR-12 coding standards
Add tests for new features
Update documentation
Ensure security best practices

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

MIT License Summary:

✅ Commercial use
✅ Modification
✅ Distribution
✅ Private use
❌ Liability
❌ Warranty

🆘 Support

📖 Documentation: docs/
🐛 Issues: GitHub Issues
💡 Feature Requests: GitHub Discussions

🎯 Roadmap

[ ] PostgreSQL support
[ ] Advanced query caching
[ ] Connection encryption (SSL/TLS)
[ ] Query performance analytics
[ ] Multi-database connection management
[ ] GraphQL-style query building

Made with ❤️ for the Claude Code community

Powered by php-mcp/server

All versions of php-mcp-mysql with dependencies

PHP Build Version

Package Version

Version v1.1.1 Release 01. Sep 2025
create-project require 0 people chose require and
0 people chose create-project.

Download

Download latest version of php-mcp-mysql from vendor momodemo333

Requires php Version >=8.1
php-mcp/server Version ^3.3
ext-pdo Version *
ext-pdo_mysql Version *

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package momodemo333/php-mcp-mysql contains the following files

Loading the files please wait ....