{"id":"dbt-api","name":"dbt Cloud","homepage":"https://www.getdbt.com","repo_url":"https://github.com/dbt-labs/dbt-core","category":"data-pipeline","subcategories":["data-transformation","analytics-engineering","data-engineering"],"tags":["dbt","data-transformation","sql","analytics-engineering","data-pipeline","mcp"],"what_it_does":"Data transformation platform that lets analytics engineers define SQL-based transformations as code, with dbt Cloud offering a managed service with REST API and MCP server for orchestrating transformation runs.","use_cases":["Triggering dbt model runs programmatically as part of data pipeline orchestration","Querying run status and surfacing model-level failures in automated workflows","Discovering available models, sources, and their lineage via the Metadata API","Managing environment variables and job configurations across environments","Building CI/CD pipelines that run dbt tests on pull request before deployment"],"not_for":["Data ingestion or ELT from sources (dbt only transforms; pair with Airbyte or Fivetran)","Real-time data transformation (dbt is batch SQL; use Flink or Kafka Streams)","Teams without a SQL data warehouse (Snowflake, BigQuery, Redshift, etc.)","Simple reporting without complex transformation logic"],"best_when":"Your data team uses SQL-based transformations in a cloud data warehouse and you want to automate, schedule, and govern those transformations with version control and testing.","avoid_when":"You don't have a cloud data warehouse, need real-time transformations, or are doing simple ad-hoc queries without a transformation layer.","alternatives":["airbyte-api","fivetran-api","dagster-api"],"af_score":77.9,"security_score":78.0,"reliability_score":null,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":"current","last_evaluated":"2026-03-01T09:50:05.475724+00:00","performance":{"latency_p50_ms":120,"latency_p99_ms":500,"uptime_sla_percent":99.9,"rate_limits":"API rate limits vary by endpoint; Metadata GraphQL API has usage limits by plan","data_source":"llm_estimated","measured_on":null}}