proxysql

Commit Graph

Author	SHA1	Message	Date
Rene Cannao	e9a6dd0b3e	Add comprehensive MCP testing suite in scripts/mcp/ Created a complete testing suite for the MCP module with MySQL connection pool and exploration tools. Files added: - README.md: Comprehensive testing documentation - setup_test_db.sh: Docker-based test MySQL database setup - Start/stop/status/connect commands - Creates sample schema (customers, orders, products, order_items) - Includes views and stored procedures for testing - configure_mcp.sh: ProxySQL MCP module configuration - Configures MySQL connection parameters - Enables/disables MCP server - Shows current configuration status - test_mcp_tools.sh: Main MCP tools test suite - Tests all 15 MCP tools (list_schemas, list_tables, etc.) - Includes catalog tests (upsert, get, search, delete) - Reports pass/fail statistics - stress_test.sh: Concurrent connection stress testing - Configurable number of concurrent requests - Response time measurement - Success rate calculation - test_catalog.sh: Catalog/LLM memory specific tests - 12 catalog operation tests - FTS search testing - CRUD verification All scripts are executable and include: - Command-line argument parsing - Colored output for readability - Error handling and validation - Usage/help documentation - Environment variable support	4 months ago

Author

SHA1

Message

Date

Rene Cannao

e9a6dd0b3e

Add comprehensive MCP testing suite in scripts/mcp/

Created a complete testing suite for the MCP module with MySQL
connection pool and exploration tools.

Files added:
- README.md: Comprehensive testing documentation
- setup_test_db.sh: Docker-based test MySQL database setup
  - Start/stop/status/connect commands
  - Creates sample schema (customers, orders, products, order_items)
  - Includes views and stored procedures for testing
- configure_mcp.sh: ProxySQL MCP module configuration
  - Configures MySQL connection parameters
  - Enables/disables MCP server
  - Shows current configuration status
- test_mcp_tools.sh: Main MCP tools test suite
  - Tests all 15 MCP tools (list_schemas, list_tables, etc.)
  - Includes catalog tests (upsert, get, search, delete)
  - Reports pass/fail statistics
- stress_test.sh: Concurrent connection stress testing
  - Configurable number of concurrent requests
  - Response time measurement
  - Success rate calculation
- test_catalog.sh: Catalog/LLM memory specific tests
  - 12 catalog operation tests
  - FTS search testing
  - CRUD verification

All scripts are executable and include:
- Command-line argument parsing
- Colored output for readability
- Error handling and validation
- Usage/help documentation
- Environment variable support

1 Commits (mysqlx-plugin-impl)