# ClickHouse vs Mathesar — Fit & Features

Canonical: https://trutool.co/compare/clickhouse-vs-mathesar
Author: Snehil (https://trutool.co/authors/snehil)

Compare ClickHouse and Mathesar by use case, features, limitations, and evaluation questions.

## Compare fit, features, and limitations

### ClickHouse
Analytical database and query processing.
Best fit: Developers and data teams considering ClickHouse for this job: Analytical database and query processing.
- Analytical database and query processing
Before you choose: Test query performance on your workload, backups, access control, portability, and storage costs in the exact plan you intend to use.
Pricing: https://clickhouse.com
- [Read ClickHouse profile](https://trutool.co/tools/clickhouse): Read ClickHouse profile

### Mathesar
Mathesar is a straightforward open source tool that provides a spreadsheet-like interface to a PostgreSQL database. Our web-based interface helps you and your collaborators work with data more independently and comfortably – no technical skills needed.
Best fit: People and teams evaluating databases & data platforms for a specific workflow.
- Data workflows
Before you choose: Test a representative task, inspect outputs, and confirm integrations, permissions, data handling, licensing, and current costs.
Pricing: https://mathesar.org
- [Read Mathesar profile](https://trutool.co/tools/mathesar): Read Mathesar profile