#!/usr/bin/env node
/**
* mysql-mcp - Command Line Interface
*
* Entry point for running the mysql-mcp server from the command line.
*/
import { createServer } from "./server/McpServer.js";
import { MySQLAdapter } from "./adapters/mysql/MySQLAdapter.js";
import type {
McpServerConfig,
DatabaseConfig,
OAuthConfig,
} from "./types/index.js";
import { parseArgs } from "./cli/args.js";
import { logger } from "./utils/logger.js";
/**
* Tool groups that don't require a MySQL database connection.
* These tools connect to external services via HTTP/CLI.
*/
const MYSQL_OPTIONAL_GROUPS = new Set(["router", "proxysql", "shell"]);
/**
* Check if the tool filter only includes groups that don't need MySQL connection.
* Returns true if MySQL connection can be skipped.
*/
function canSkipMySQLConnection(toolFilter: string | undefined): boolean {
if (!toolFilter) return false;
// Parse the filter to extract enabled groups
// Format examples: "router", "router,proxysql", "ecosystem", "-core,router"
const parts = toolFilter.split(",").map((p) => p.trim().toLowerCase());
// If using shortcuts that include MySQL-requiring tools, need connection
const shortcutsRequiringMySQL = [
"starter",
"essential",
"dev-power",
"ai-data",
"ai-spatial",
"dba-monitor",
"dba-manage",
"dba-secure",
"base-core",
"base-advanced",
];
// Check if any shortcut requiring MySQL is used
for (const part of parts) {
const cleanPart = part.replace(/^[+-]/, "");
if (shortcutsRequiringMySQL.includes(cleanPart)) {
return false;
}
}
// Get all positive (included) groups
const enabledGroups = new Set<string>();
for (const part of parts) {
if (part.startsWith("-")) continue; // Skip exclusions
const cleanPart = part.replace(/^[+]/, "");
// 'ecosystem' shortcut = router + proxysql + shell + cluster
// Note: cluster requires MySQL, so ecosystem no longer skips MySQL connection
if (cleanPart === "ecosystem") {
enabledGroups.add("router");
enabledGroups.add("proxysql");
enabledGroups.add("shell");
enabledGroups.add("cluster");
} else {
enabledGroups.add(cleanPart);
}
}
// If no enabled groups found, can't skip
if (enabledGroups.size === 0) return false;
// Check if ALL enabled groups are MySQL-optional
for (const group of enabledGroups) {
if (!MYSQL_OPTIONAL_GROUPS.has(group)) {
return false;
}
}
return true;
}
/**
* Main entry point
*/
export async function main(args?: {
config: Partial<McpServerConfig>;
databases: DatabaseConfig[];
oauth: OAuthConfig | undefined;
shouldExit?: boolean;
}): Promise<void> {
const { config, databases, oauth, shouldExit } = args ?? parseArgs();
if (shouldExit) {
process.exit(0);
}
// Check if MySQL connection can be skipped based on tool filter
const skipMySQLConnection = canSkipMySQLConnection(config.toolFilter);
if (databases.length === 0 && !skipMySQLConnection) {
console.error("Error: No database connection specified");
console.error(
"Use --mysql or environment variables to configure connection",
);
console.error("Run with --help for usage information");
process.exit(1);
}
// Log OAuth status (without exposing sensitive configuration)
if (oauth?.enabled) {
console.error("OAuth authentication enabled");
}
// Create server
const server = createServer({
...config,
databases,
oauth,
});
// Handle graceful shutdown
const shutdown = async (): Promise<never> => {
console.error("\nShutting down...");
await server.stop();
process.exit(0);
};
process.on("SIGINT", () => void shutdown());
process.on("SIGTERM", () => void shutdown());
try {
// Create and connect adapters
for (const dbConfig of databases) {
if (dbConfig.type === "mysql") {
const adapter = new MySQLAdapter();
if (skipMySQLConnection) {
// Register adapter without connecting for external-only tools
logger.info(
"Skipping MySQL connection (not needed for selected tools)",
{
toolFilter: config.toolFilter,
},
);
server.registerAdapter(
adapter,
`mysql:${dbConfig.database ?? "default"}`,
);
} else {
// Normal flow: connect then register
await adapter.connect(dbConfig);
server.registerAdapter(
adapter,
`mysql:${dbConfig.database ?? "default"}`,
);
}
}
}
// If no databases configured but using external-only tools, create a placeholder adapter
if (databases.length === 0 && skipMySQLConnection) {
logger.info("Running without MySQL connection (external tools only)", {
toolFilter: config.toolFilter,
});
const adapter = new MySQLAdapter();
server.registerAdapter(adapter, "mysql:external");
}
// Start server
await server.start();
} catch (error) {
console.error("Fatal error:", error);
process.exit(1);
}
}
// Run if called directly
import { fileURLToPath } from "url";
// Only run if this file is the main module
const isMainModule = process.argv[1] === fileURLToPath(import.meta.url);
if (isMainModule) {
main().catch(console.error);
}
