# Numeracy > Independent buyer’s guides to SQL tools and the data stack. We show the math. Independent; not affiliated with Snowflake or the former Numeracy SQL editor. Every price links to the vendor page it came from, with the date it was checked. ## Data - [SQL client price index](https://numeracy.co/data/sql-client-price-index/): sourced, dated prices, licenses, platforms and databases for desktop SQL clients. CSV: https://numeracy.co/data/sql-clients.csv ## Categories - [SQL tool comparisons, head-to-head](https://numeracy.co/compare/): SQL tool comparisons head-to-head. Each opens with pick A if, pick B if, shows sourced prices and links to the alternatives pages for both tools. - [Learn SQL: a path from first query to job-ready](https://numeracy.co/learn-sql/): Learn SQL with sourced course lengths and prices, a path from first query to interview, and honest numbers on how long it takes. - [SQL editors and clients, compared](https://numeracy.co/sql-editors/): SQL editors and clients compared on price per seat, license, operating system and supported databases, with sourced and dated tables. ## Comparisons, alternatives and roundups - [Azure Data Studio alternatives worth switching to](https://numeracy.co/sql-editors/azure-data-studio-alternatives/): The best Azure Data Studio alternatives start with Visual Studio Code and the MSSQL extension, which Microsoft recommends, free on Windows, macOS and Linux. Best free pick: DBeaver Community. Keep SSMS for SQL Server Agent and full administration on Windows. - [Best SQL editor: free and paid picks compared](https://numeracy.co/sql-editors/best-sql-editor/): DBeaver Community is the best SQL editor for most people: free, open source, and it runs on Windows, macOS and Linux. Pick DataGrip for deep SQL coding, TablePlus for a native Mac app, and SSMS for SQL Server on Windows. - [DataGrip alternatives: do you still need one?](https://numeracy.co/sql-editors/datagrip-alternatives/): DataGrip alternatives matter mainly for paid work: learners and hobbyists no longer need one, since DataGrip is free for non-commercial use. DBeaver Community is the best free alternative and TablePlus ($99 one-time) the best paid pick. - [DataGrip vs DBeaver: which one fits you?](https://numeracy.co/sql-editors/datagrip-vs-dbeaver/): DataGrip vs DBeaver comes down to license: DBeaver Community is a free, open-source client you can use at work. DataGrip is a paid JetBrains IDE, free if your use is non-commercial; it costs $259 per user per year for organizations. - [DBeaver alternatives worth switching to](https://numeracy.co/sql-editors/dbeaver-alternatives/): The best DBeaver alternatives are DataGrip for paid work (50+ databases, $109 a year for one person), DbGate Community for free use (open source, no seat fee) and TablePlus for a native Mac app. - [DBeaver vs pgAdmin: which one fits you?](https://numeracy.co/sql-editors/dbeaver-vs-pgadmin/): DBeaver vs pgAdmin: pick pgAdmin if you only run PostgreSQL and need server admin (roles, VACUUM, backups, graphical EXPLAIN), or DBeaver Community if you use other databases too. Both are free; DBeaver adds paid editions from $113 a year. - [SQL client for Mac: the best native and free picks](https://numeracy.co/sql-editors/sql-client-for-mac/): TablePlus is the best native SQL client for Mac at $99 one-time. DBeaver Community is the best free one. Use Postico 2 for PostgreSQL, Sequel Ace for MySQL, and VS Code with the MSSQL extension for SQL Server. - [TablePlus alternatives: native Mac and free options](https://numeracy.co/sql-editors/tableplus-alternatives/): The best TablePlus alternatives are DataGrip for paid work ($109 a year), Sequel Ace for free MySQL on Mac, and DBeaver Community for everything else free. Postico 2 is the closest native Mac swap for PostgreSQL. - [TablePlus vs DBeaver: which one fits you?](https://numeracy.co/sql-editors/tableplus-vs-dbeaver/): TablePlus vs DBeaver: pick TablePlus for a fast native app on a $99 one-time license with one year of updates, or DBeaver Community for free, open source and more databases. TablePlus's free trial caps you at 2 tabs. ## Guides and explainers - [Correlated subquery in SQL: how it runs and when to rewrite it](https://numeracy.co/learn-sql/correlated-subquery/): A correlated subquery references a column from the outer query, so it cannot run alone. Logically it re-runs once per outer row. Optimizers often rewrite it as a join, so check your database's plan. - [SQL interview questions for data analyst roles](https://numeracy.co/learn-sql/sql-interview-questions-for-data-analyst/): SQL interview questions for data analyst roles test joins, GROUP BY with HAVING, NULL handling, date filters, CTEs, window functions and query order. Practice them on one small schema, and explain why each query works, not only what it returns. - [The life of a SQL query: SQL order of execution](https://numeracy.co/learn-sql/sql-order-of-execution/): SQL order of execution is logical: FROM/JOIN, WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY, LIMIT. Physically, the engine parses, rewrites, plans with a cost model, then executes the chosen plan and returns rows. - [SQL practice datasets: free databases to query](https://numeracy.co/learn-sql/sql-practice-datasets/): SQL practice datasets to start with: Sakila or Pagila for joins, Chinook or AdventureWorks for business reports, and NYC taxi Parquet files in DuckDB for large tables. BigQuery gives 1 TiB of free queries a month on public datasets. - [SQL window functions cheat sheet](https://numeracy.co/learn-sql/sql-window-functions-cheat-sheet/): A SQL window functions cheat sheet starts with one idea: a window function computes a value per row without collapsing rows like GROUP BY. Write function() OVER (PARTITION BY ... ORDER BY ... frame); all window functions share that clause. - [SSMS for Mac: is there one, and what to use instead](https://numeracy.co/sql-editors/ssms-for-mac/): No, there is no SSMS for Mac: Microsoft says SSMS is available only for Windows. Azure Data Studio was retired on Feb 28, 2026. Microsoft recommends VS Code with the MSSQL extension. DataGrip, DBeaver and TablePlus also work. ## About - [About Numeracy](https://numeracy.co/about-numeracy/): About Numeracy: Numeracy is an independent buyer’s guide to SQL tools and the data stack, edited by Kuldeep Singh, with sourced and dated prices. - [Kuldeep Singh](https://numeracy.co/authors/kuldeep-singh/): Kuldeep Singh is an independent SQL consultant with 15+ years of SQL experience, a former Deloitte technology consultant and the editor of Numeracy. - [Contact Numeracy](https://numeracy.co/contact/): Contact Numeracy to report a wrong price, send a vendor pricing update, ask about our data or citations, or discuss a partnership. Email hello@numeracy.co. - [SQL client price index](https://numeracy.co/data/sql-client-price-index/): SQL client price index of per-seat prices, licenses, platforms and databases for desktop SQL editors, each sourced from the vendor and dated. Free CSV. - [How we research](https://numeracy.co/how-we-research/): How we research SQL tools: where prices come from, how we date them, how we order tools, what we never claim, and how we fix mistakes. Data is CC BY 4.0.