General Uses

General benefits and use cases of ChartSQL

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 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 for SQL administration and editing.