> For the complete documentation index, see [llms.txt](https://docs.chartsql.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.chartsql.com/product-and-community/use-cases/general-uses.md).

# General Uses

## Key Benefits

* **Quick Prototyping:** Quickly explore and visualize SQL queries
* **SQL & Charts Together:** Keep your SQL query and visualization together in one file so that they stay in sync
* **Query, Chart, Present:** Quickly move from a query, to a chart, to an attractive presentation in a seamless workflow without any copy/paste or manual work
* **Collaborate:** Collaborate on your SQL and charts in source code like git

## ChartSQL Limitations

* ChartSQL is best as the visualization layer with relatively simple shaping that can be done in a single query. If you need to do complex and expensive SQL calculations, using something like [DBT](https://www.getdbt.com/) or your data warehouse to prepare the data is recommended.
* Although ChartSQL Studio has SQL management features, is not a general SQL editor. We like [Dbeaver](https://dbeaver.com/) for SQL administration and editing.