Download the PHP package winningsoftware/database-assistant-mcp-server without Composer
On this page you can find all versions of the php package winningsoftware/database-assistant-mcp-server. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download winningsoftware/database-assistant-mcp-server
More information about winningsoftware/database-assistant-mcp-server
Files in winningsoftware/database-assistant-mcp-server
Package database-assistant-mcp-server
Short Description A PHP based MCP server for querying SQL databases.
License GPL-3.0-or-later
Informations about the package database-assistant-mcp-server
Database Assistant MCP Server
A lightweight PHP-based Model Context Protocol server that gives AI assistants read-only access to your MySQL databases.
Features
- Expose multiple MySQL databases to any MCP-compatible client
- Read-only by design — only
SELECT,SHOW,DESCRIBE, andEXPLAINqueries are permitted - Simple YAML configuration
- Zero framework dependencies
Requirements
- PHP 8.4+
ext-pdoandext-pdo_mysqlext-yaml(for config parsing)
Installation
Configuration
Create a YAML config file anywhere on your system. The server accepts the path to this file as its only argument.
Structure
Each key under databases becomes a target alias that the AI client uses when issuing queries.
| Field | Type | Required | Default | Description |
|---|---|---|---|---|
host |
string | yes | — | MySQL hostname or IP |
username |
string | yes | — | Database user |
password |
string | yes | — | Database password |
port |
int | no | 3306 | MySQL port |
name |
string | no | — | Default database/schema name |
Example
Usage
Your MCP client starts and manages the server process automatically — you don't need to run it manually. Just add it to
your client config (e.g. mcp.json):
If installed globally via Composer, the binary path will typically be ~/.composer/vendor/bin/database-assistant-mcp-server
or ~/.config/composer/vendor/bin/database-assistant-mcp-server.
AI Skill File
A SKILL.md file is included in the project root. Copy it into your AI client's skills directory to give the assistant
context on how to use this server effectively (schema discovery workflow, output formatting, etc.).
Security Considerations
- The server enforces read-only access at the application level. Only
SELECT,SHOW,DESCRIBE, andEXPLAINstatements are executed. - For defence in depth, connect with a MySQL user that has read-only privileges.
- Keep your config YAML outside of version control — it contains credentials.
License
GPL-3.0-or-later
All versions of database-assistant-mcp-server with dependencies
ext-yaml Version *
ext-pdo Version *
ext-pdo_mysql Version *