{"id":"bigquery-api","name":"BigQuery API","homepage":"https://cloud.google.com/bigquery/docs/reference/rest","repo_url":"https://github.com/googleapis/google-cloud-python/tree/main/packages/google-cloud-bigquery","category":"data","subcategories":["analytics","data-warehouse","sql","etl"],"tags":["bigquery","gcp","google","data-warehouse","analytics","sql","rest-api","sdk","large-scale"],"what_it_does":"Google's fully managed, serverless data warehouse REST API and Python client. Enables agents to run SQL queries against petabyte-scale datasets, create and manage tables, load data, stream inserts, and run ML models. Pay-per-query pricing with a generous free tier.","use_cases":["Running analytical SQL queries against large datasets for agent-driven insights","Streaming operational data into BigQuery for near-real-time analytics","Querying aggregated business metrics for reporting agents","Loading batch data exports from other systems into BigQuery for analysis","Running BQML models for in-database machine learning from agents","Exporting query results to GCS for downstream agent processing"],"not_for":["Low-latency OLTP workloads (use Cloud Spanner or Firestore instead)","Frequent small queries where per-query costs add up (cache strategically)","Key-value lookups (use Firestore, Bigtable, or Redis instead)","Real-time streaming with sub-second freshness requirements"],"best_when":"An agent needs to analyze large datasets with SQL — reporting, aggregation, historical analysis, or data exploration at scale on GCP.","avoid_when":"You need low-latency row-level lookups, or your query patterns involve many small queries that would be expensive per-query.","alternatives":["snowflake-api","gcp-python-client","clickhouse-api"],"af_score":80.1,"security_score":null,"reliability_score":null,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":"current","last_evaluated":"2026-03-01T09:50:05.323629+00:00","performance":{"latency_p50_ms":500,"latency_p99_ms":5000,"uptime_sla_percent":99.99,"rate_limits":"300 concurrent queries per project, 1,500 table operations/day, 10GB streaming insert quota. Queries are async — small queries return in seconds, large queries in minutes.","data_source":"llm_estimated","measured_on":null}}