ecosystem.config.js•1.68 kB
// PM2 ecosystem file for mcp-sql
// Rename credentials and host before using in production.
module.exports = {
apps: [
{
name: "mcp-sql",
script: "mcp_server.py",
interpreter: "./mcp-sql/venv/bin/python3",
cwd: "./mcp-sql",
instances: 1,
watch: true,
// Environment-based configuration (recommended)
// NOTE: With the new multi-client support, you can leave credentials empty here
// and have each client provide their own credentials in their IDE configuration.
// This is more secure as the server doesn't store any credentials.
env: {
// Optional: Configure default credentials for shared access
// Uncomment the following lines if you want server-wide credentials:
//MCP_SQL_USER: "your_username",
//MCP_SQL_PASSWORD: "your_password",
//MCP_SQL_SERVER: "your_server.local",
//MCP_SQL_DATABASE: "master",
//MCP_SQL_DRIVER: "ODBC Driver 18 for SQL Server",
//MCP_SQL_NAME: "mcp-sql",
// Server port (required)
MCP_PORT: "35001"
}
// Alternatively, you can use CLI flags instead of env vars. Uncomment and edit below:
// args: [
// "--dsn",
// "mssql+pyodbc://USER:PASSWORD@HOST/master?driver=ODBC+Driver+18+for+SQL+Server&TrustServerCertificate=yes",
// "--name",
// "prod-sql",
// "--port",
// "3939"
// ]
}
]
}