Library — DistroSource

Everything digital. One source.

9 resources

Tool · Beginner · 3 min
JSON formatter
Validate and pretty-print a JSON payload before you use it.
- Pretty-prints, minifies or sorts keys in any JSON payload and reports the first syntax error with its position.
ChatGPTClaude
Tool · Beginner · 3 min
SQL formatter
Make a long query readable before it goes into review.
- Upper-cases keywords and breaks a query into one clause per line so reviewers can read it.
ChatGPTClaude
Checklist · Beginner · 10 min
Before sharing an assistant-produced analysis checklist
The checks between a generated number and a decision.
- A confident wrong number travels fast. Run this before sending.
- ☐ The definition of each metric is written down
- ☐ The query was run by you and the code is saved
Items 10ChatGPTClaude
Code recipe · Advanced · 15 min
Cohort retention table in SQL
Compute monthly retention by signup cohort in one query.
- Retention by cohort is the chart everyone wants and the query everyone gets subtly wrong; this version counts each subscriber once per month.
Language SQLChatGPTClaude
AI tool guide · Beginner · 20 min
ChatGPT data analysis for AI data analysis
Use the data analysis feature to explore a file with code you can read, not answers you must trust.
- Uploading a CSV to ChatGPT's data analysis mode lets it write and run Python to profile, chart and summarise the data; the code it runs is visible, which is what makes the output checkable.
- Workflow: First look at a file
- Workflow: A chart with the code
ChatGPTClaude
Automation recipe · Intermediate · 45 min
Anomaly detection on a daily metric: automation recipe
Build anomaly detection on a daily metric as a n8n automation: post an alert when a daily metric moves outside its normal range, with the recent values attached.
- Trigger: Schedule: daily at 07:00.
- 1. Postgres
- 2. Code
Platform n8nActions 4ChatGPTClaude
Workflow · Beginner · 20 min
Weekly metrics narrative workflow
Write the narrative for a weekly metrics email from computed numbers, never from raw ones.
- When: Monday morning.
- 1. Compute in the sheet
- 2. Narrate from the table
Steps 4Tools Spreadsheet, Any assistantChatGPTClaude
Workflow · Intermediate · 1h
Data quality audit workflow
Audit a table for the problems that silently corrupt analysis and fix the definitions first.
- When: Before any analysis on a table you have not used in a month.
- 1. Profile each column
- 2. Check the joins
Steps 4Tools Any assistant, Database accessChatGPTClaude
Workflow · Intermediate · 45 min
Question to query to chart workflow
Answer a business question with a query and a chart, with the assistant writing and you verifying.
- When: A stakeholder asks a question the dashboards do not answer.
- 1. Define before querying
- 2. Write the query with a check
Steps 5Tools Any assistant, Database access, SpreadsheetChatGPTClaude

Search