.env.example

# BigQuery MCP Server Configuration

# ===== REQUIRED SETTINGS =====

# Google Cloud project ID
GCP_PROJECT_ID=your-project-id

# BigQuery location for operations
# Common values: US, EU, asia-northeast1, europe-west4 etc.
# See: https://cloud.google.com/bigquery/docs/locations
BIGQUERY_LOCATION=US

# ===== OPTIONAL SETTINGS =====

# Authentication: Path to service account JSON file
# If not set, will use Application Default Credentials
GOOGLE_APPLICATION_CREDENTIALS=/path/to/service-account.json

# Dataset Access Control: Restrict to specific datasets (comma-separated)
# If not set, allows access to all datasets in the project
BIGQUERY_ALLOWED_DATASETS=dataset1,dataset2,dataset3

# Query & Result Limits
BIGQUERY_MAX_RESULTS=20                      # Max rows returned by run_query (default: 20)
BIGQUERY_LIST_MAX_RESULTS=500                # Max results for basic list operations (default: 500)
BIGQUERY_LIST_MAX_RESULTS_DETAILED=25        # Max results for detailed list operations (default: 25)
BIGQUERY_MAX_BYTES_BILLED=21474836480        # Cap per-query spend; 20 GiB (~USD 0.10/query, $5/TiB)

# Table Analysis Settings
BIGQUERY_SAMPLE_ROWS=3                       # Sample data rows returned in get_table (default: 3)
BIGQUERY_SAMPLE_ROWS_FOR_STATS=500           # Rows sampled for column fill rate calculations (default: 500)