MCP MySQL Server

import { config } from '../src/config/index.js'; import { DatabaseManager } from '../src/database/manager.js'; import { logger } from '../src/utils/logger.js'; async function testConnection() { console.log('🔧 Testing MCP MySQL Server Configuration...\n'); try { // Test configuration loading console.log('📋 Configuration:'); console.log(` - Host: ${config.database.host}`); console.log(` - Port: ${config.database.port}`); console.log(` - User: ${config.database.user}`); console.log(` - Database: ${config.database.database || 'Multi-DB Mode'}`); console.log(` - Logging: ${config.server.enableLogging}`); console.log(''); // Test database connection console.log('🔌 Testing database connection...'); const db = DatabaseManager.getInstance(); const result = await db.executeQuery('SELECT 1 as test, NOW() as current_time'); console.log('✅ Database connection successful!'); console.log('📊 Test query result:', result.rows[0]); await db.close(); console.log('\n🎉 All tests passed! The server is ready to use.'); } catch (error) { console.error('\n❌ Test failed:', error.message); console.log('\n🔧 Troubleshooting tips:'); console.log('1. Check your .env file has correct MySQL credentials'); console.log('2. Ensure MySQL server is running'); console.log('3. Verify the user has proper permissions'); console.log('4. Test MySQL connection with mysql command line client'); process.exit(1); } } testConnection();