Turn SQL snippets into images worth sharing, without leaving your Mac.
SQL is the language people most often get wrong as an image, because a query that looks fine in a client wraps badly everywhere else.
Codeshot detects SQL from the code you paste, so there is no language picker to get wrong. Here is the same snippet in three of the 30 themes it ships with, rendered with the app's own stylesheets.
SELECT
theme,
COUNT(*) AS snapshots,
AVG(scale) AS avg_scale
FROM snapshots
WHERE created_at >= NOW() -INTERVAL'30 days'GROUPBY theme
ORDERBY snapshots DESC
LIMIT 10;
Edge · dark
SELECT
theme,
COUNT(*) AS snapshots,
AVG(scale) AS avg_scale
FROM snapshots
WHERE created_at >= NOW() -INTERVAL'30 days'GROUPBY theme
ORDERBY snapshots DESC
LIMIT 10;
GitHub · dark
SELECT
theme,
COUNT(*) AS snapshots,
AVG(scale) AS avg_scale
FROM snapshots
WHERE created_at >= NOW() -INTERVAL'30 days'GROUPBY theme
ORDERBY snapshots DESC
LIMIT 10;
Solarized · dark
Choosing a theme for SQL
Break clauses onto their own lines before you screenshot. A wide ratio helps, but formatting the query helps more.
Getting the size right
Let the image follow your content, or lock it to a ratio — 1:1, 4:3, 3:2, 16:9, 9:16, 2:3, or 3:4 — then export at 1×, 2×, or 3× so it stays sharp on a retina display. Copy it straight to the clipboard with ⌘⇧C, or save with ⌘S.