mcp-bigquery-server

import { startMcpBigQueryServer } from 'mcp-bigquery-server'; import { writeFileSync } from 'fs'; import path from 'path'; // Ensure GOOGLE_APPLICATION_CREDENTIALS is set for local development or CI/CD // For production, use Workload Identity or similar GCP-native authentication if (!process.env.GOOGLE_APPLICATION_CREDENTIALS) { console.warn('WARNING: GOOGLE_APPLICATION_CREDENTIALS not set. Using default credentials or requiring manual login.'); // Example: Point to a dummy key file if running locally without actual credentials // In a real scenario, this should be a valid path to your service account key.json } // Create a minimal configuration file for the server const config = { projectId: process.env.GCP_PROJECT_ID ?? 'your-gcp-project-id', allowedDatasets: [ `${process.env.GCP_PROJECT_ID ?? 'your-gcp-project-id'}.your_dataset_name`, 'another_project.another_dataset' ], port: parseInt(process.env.PORT ?? '8080'), auth: { mode: 'none' // Or 'bearer' with tokens: ['YOUR_API_TOKEN'] } }; const configPath = path.join(process.cwd(), 'mcp-server-config.json'); writeFileSync(configPath, JSON.stringify(config, null, 2)); console.log(`MCP BigQuery Server configuration written to ${configPath}`); async function main() { try { // Start the server programmatically, passing the config directly or via file path // Alternatively, use `npx mcp-bigquery-server --config-file ./mcp-server-config.json` console.log('Starting MCP BigQuery Server...'); const server = await startMcpBigQueryServer({ config: config, logLevel: 'info' // Example: Set logging level }); console.log(`MCP BigQuery Server running on port ${server.port} for project ${server.projectId}`); console.log('Use this server with your LLM-integrated IDE (e.g., Augment Code, Cursor).'); // Keep the process alive // process.on('SIGINT', () => { // server.stop(); // process.exit(0); // }); } catch (error) { console.error('Failed to start MCP BigQuery Server:', error); process.exit(1); } } main();