/**
* MySQL数据库配置文件
*/
const mysql = require('mysql2/promise');
require('dotenv').config();
// 数据库连接配置
const dbConfig = {
host: process.env.DB_HOST || 'localhost',
port: parseInt(process.env.DB_PORT || '3306'),
user: process.env.DB_USER || 'root',
password: process.env.DB_PASSWORD,
database: process.env.DB_NAME || 'mcp_system',
waitForConnections: true,
connectionLimit: 10,
queueLimit: 0,
dateStrings: true
};
// 创建连接池
const pool = mysql.createPool(dbConfig);
// 测试连接
async function testConnection() {
try {
const connection = await pool.getConnection();
console.log('数据库连接成功');
connection.release();
return true;
} catch (error) {
console.error('数据库连接失败:', error.message);
return false;
}
}
module.exports = {
pool,
testConnection
};