If you need state-aware SQLMesh transforms, Tobiko Cloud is the first tool to look at here. Astronomer Astro is the stronger choice for managed Airflow for Python DAGs, while dbt Cloud suits SQL-first transform teams. Details, prices and limits for the rest of the 6 tools are below.
We run no ads and no affiliate links at launch. The order of a list follows our published method.
Prices are the starting prices vendors list publicly. Plans change, so confirm the current price on the vendor page before you buy.
Key takeaways
The list opens with Tobiko Cloud, aimed at state-aware SQLMesh transforms.
A fair warning about Tobiko Cloud: no published price and no free level listed.
For low-code pushdown SQL in the warehouse, Matillion is worth a look.
Starting prices begin at $10 per month with Dagster+.
A free plan is available from 2 of the 6 tools: dbt Cloud, Prefect Cloud.
Tool
Best for
Standout feature
Listed starting price
Free plan or trial
1 Tobiko Cloud
State-aware SQLMesh transforms
Per-model warehouse cost tracking for BigQuery and Snowflake
Quote only
No free plan
2 Astronomer Astro
Managed Airflow for Python DAGs
Deployment sizes from small to large
$0.35 per hour
No free plan
3 dbt Cloud
SQL-first transform teams
Tests and docs built into the model workflow
$100 per user/month
Free plan
4 Dagster+
Asset-first orchestration
Asset-level lineage and freshness policies
$10 a month
Free trial (30 days)
5 Prefect Cloud
Flat-priced Python orchestration
Flat seat pricing with no charge per run
$100 a month
Free plan
6 Matillion
Low-code pushdown SQL in the warehouse
Visual low-code canvas with SQL and Python
Quote only
Free trial
How we picked
DoCodeHere looked at what each vendor publishes: pricing, plan limits, feature coverage for tools for SQL automation and stated drawbacks. No hands-on testing is claimed. Figures are shown as the vendors publish them. Billing terms, seat minimums and add-ons can change the real cost. The ranking is editorial: typical fit first, then clear pricing, then free access. If your needs are unusual, read the profiles rather than relying on position.
01
Tobiko Cloud
Best for: State-aware SQLMesh transforms
Tobiko Cloud was built for state-aware SQLMesh transforms. Tobiko Cloud is the hosted version of SQLMesh, designed for teams that want SQL transforms with state-aware execution, so only changed models and their dependents are rebuilt. Its pricing has two parts, a system fee for access to all features and a pay-as-you-go fee for consumption.
What to check first: the only no-cost route is self-hosted open-source SQLMesh.
The vendor does not publish either number, so the starting price is quote only. One limit: there is no free level listed, and the open-source SQLMesh project is the only no-cost route, which means you run and maintain it yourself. On top of that, Tobiko Cloud brings column-level lineage, virtual test environments, a unified debugger and warehouse cost tracking per model for BigQuery and Snowflake There is no list price for Tobiko Cloud, so a quote is the way in. Tobiko Cloud has no free plan.
Pros
Per-model warehouse cost tracking for BigQuery and Snowflake
State-aware execution rebuilds only changed models
Cons
No published price and no free level listed
Price: Quote only, as listed by the vendor (Tobiko Cloud website). Confirm the current plan price before you buy.
Skip it if this limit matters to you: no published price and no free level listed.
Verdict. A sensible pick for state-aware SQLMesh transforms.
02
Astronomer Astro
Best for: Managed Airflow for Python DAGs
Astronomer Astro is built with managed Airflow for Python DAGs in mind. Astro is the managed Airflow service from Astronomer, and it is the pick when your SQL automation lives inside bigger Python workflows. More specifically, standard multi-tenant clusters are included on all plans, whereas a dedicated cluster opens at $2.40 per hour on Team.
Limits to weigh: No free level listed on the pricing page.
One limit: the pricing page lists no free level, and networking costs are passed through from the cloud provider. So the monthly total relies on data Beyond that, workers scale to zero when idle, so you only pay for worker compute whereas tasks run, and a small deployment left running all month costs about $255.50 The starting price for Astronomer Astro: $0.35 per hour. Astronomer Astro has no free plan.
Pros
Deployment sizes from small to large
Workers scale to zero when idle
Cons
Networking costs are passed through from the cloud provider
Price: $0.35 per hour, as listed by the vendor (Astronomer Astro website). Confirm the current plan price before you buy.
Skip it if this limit matters to you: networking costs are passed through from the cloud provider.
Verdict. A sensible pick for managed Airflow for Python DAGs.
03
dbt Cloud
Best for: SQL-first transform teams
Where dbt Cloud fits: SQL-first transform teams. dbt Cloud is the hosted version of dbt, the SQL-first transform layer that turns raw warehouse tables into tested, documented models. Also, starter is $100 per user a month for up to five developer seats, with 15,000 successful models built per month, 5,000 queried metrics per month and one On top of that, the Developer plan is free for one seat, 3,000 successful models built per month and one project.
Points against: Enterprise is custom priced with no published rate.
On top of that, one limit: dbt Cloud schedules and runs SQL models. But it does not orchestrate non-SQL work for example Python jobs or API calls, so teams with mixed pip The meter to watch is models built, not seats. Starting cost for dbt Cloud: $100 per user/month. dbt Cloud offers a free plan.
Pros
Tests and docs built into the model workflow
Semantic Layer and Catalog on Starter
Cons
Starter caps at 5 developer seats and 1 project
Price: $100 per user/month, as listed by the vendor (dbt Cloud website). Confirm the current plan price before you buy.
Skip it if this limit matters to you: starter caps at 5 developer seats and 1 project.
Verdict. A sensible pick for SQL-first transform teams.
04
Dagster+
Best for: Asset-first orchestration
Where Dagster+ fits: asset-first orchestration. Starter is $100 per month plus $0.035 per credit, for up to three users, five code locations, one deployment and Catalog Search, also with a 30-day trial.
The main drawbacks: single sign-on is held for Pro.
In daily use, Dagster+ is the managed version of Dagster, an asset-first orchestrator where you define data assets and Dagster works out the order, lineage and freshness. On cost, Dagster+ starts like this: $10 per month. Free plan details: Free trial (30 days).
Pros
Asset-level lineage and freshness policies
Hybrid deployments carry no Dagster compute charge
Cons
A credit is charged per asset materialization and per op, so one run can consume plenty of credits
Price: $10 a month, as listed by the vendor (Dagster+ website). Confirm the current plan price before you buy.
Skip it if this limit matters to you: A credit is charged per asset materialization and per op, so one run can consume plenty of credits.
Verdict. A sensible pick for asset-first orchestration.
05
Prefect Cloud
Best for: Flat-priced Python orchestration
Prefect Cloud is designed for flat-priced Python orchestration. The Hobby level is free forever for two users, with up to five deployments, 500 minutes of Prefect Serverless per month and seven days of run retention. One limit: the Hobby level caps at five deployments, so a sixth flow means deleting one or moving to Starter, and single sign-on, role-based access con Starter is $100 per month for three users, with up to 20 deployments, 75 hours of Prefect Serverless, webhooks and a 1,250 requests per minute API limit.
Drawbacks to consider: single sign-on and audit logs are held for Enterprise.
Team is $100 per user a month for four to eight users, with up to 100 deployments and 225 hours of Serverless. Prefect states that pricing is based on seats and workspaces, not on runs or task volume. So a busy month costs the same as a quiet one at the same se On cost, Prefect Cloud starts like this: $100 per month. Free access exists with Prefect Cloud.
Pros
Flat seat pricing with no charge per run
Bring your own compute on Starter
Cons
Hobby caps at 5 deployments
Price: $100 a month, as listed by the vendor (Prefect Cloud website). Confirm the current plan price before you buy.
Skip it if this limit matters to you: hobby caps at 5 deployments.
Verdict. A sensible pick for flat-priced Python orchestration.
06
Matillion
Best for: Low-code pushdown SQL in the warehouse
Matillion is a good fit for low-code pushdown SQL in the warehouse. Matillion, now branded Maia, is a low-code system that builds pipelines and runs transformations as SQL inside Snowflake, Databricks, Redshift or BigQuery. It sells three plans, Developer, Teams and Scale, as fixed annual packages that contain credits, and it does not publish a per-credit price, so the starting price is quote only.
From a buyer's view, every transformation runs in your warehouse, so warehouse compute is a second bill on top of the Matillion package. The two move together as workl More specifically, one limit: with no published unit price, you cannot model the first-year cost from the website alone, so get the credit price and the included credit Matillion sells by quote instead of a published price. Trial and free access: Free trial.
Downsides: No published per-credit price, so the first-year cost cannot be modeled from the website.
Pros
Visual low-code canvas with SQL and Python
Transformations run as pushdown SQL inside your warehouse
Cons
Warehouse compute is a second bill
Price: Quote only, as listed by the vendor (Matillion website). Confirm the current plan price before you buy.
Skip it if this limit matters to you: warehouse compute is a second bill.
Verdict. A sensible pick for low-code pushdown SQL in the warehouse.
What to check before you buy
Get a written quote from Tobiko Cloud and Matillion; the list shows no starting price for them.
Check what the free option really includes: dbt Cloud and Prefect Cloud offer a free plan, and usage caps differ.
Use real work to test the free trial from Dagster+ and Matillion, rather than a demo project.
Read the limits listed for Tobiko Cloud first: no published price and no free level listed.
See whether Tobiko Cloud offers onboarding or training, and whether it is included in the price.
The entry price of Astronomer Astro is only the starting point; model the full cost with seats and extras.
FAQ
Which tool is a good match for SQL automation for most teams?
Start with Tobiko Cloud if you need state-aware SQLMesh transforms. Astronomer Astro is the better match for managed Airflow for Python DAGs, and dbt Cloud for SQL-first transform teams. The best choice depends on budget, team size and workflow.
How are the tools for tools for SQL automation ordered?
Tobiko Cloud sits first and Matillion last because the order follows typical fit for tools for SQL automation, then price clarity and free access. It is a judgement call, so read each profile for fit and limits.
Is Tobiko Cloud the right pick for everyone comparing tools for SQL automation?
No single tool suits every team. Tobiko Cloud comes first because it fits state-aware SQLMesh transforms, while Astronomer Astro suits managed Airflow for Python DAGs and dbt Cloud suits SQL-first transform teams. Match the tool to your own size, budget and workflow before deciding.
Can I try these tools before paying?
Often, yes. dbt Cloud and Prefect Cloud have a free plan and Dagster+ and Matillion offer a free trial. Use your own data and a real task during the test, and check what the free tier or trial limits before you rely on it.
Which options for tools for SQL automation have a free plan?
dbt Cloud and Prefect Cloud offer a free plan in this list. Free plans usually cap users, projects or features, so check the limits on the vendor page. Several others offer a trial instead.