# Desk log NMD-CPG-20260822

**Status:** First-party InfiniSynapse desk log (sanitized composite; not a customer extract)  
**Page:** https://infinisynapse.com/en/blog/connect-postgres-to-ai  
**Run ID:** `NMD-CPG-20260822`  
**Date:** 2026-08-22 (Saturday)  
**Operator:** InfiniSynapse Data Team  
**Attestor:** William Zhu, InfiniSynapse cofounder ([GitHub @allwefantasy](https://github.com/allwefantasy))  
**Contact for contradictions:** zhuhl@infinisynapse.com

## What this file is

A downloadable record of guessing a schema in chat versus authorizing a SELECT-only Postgres login. It is **not** a named-logo customer case, a vendor bake-off, or a Stanford / NSF / EPA experiment.

## Four-step method (reproducible)

1. Create a SELECT-only role. Revoke INSERT, UPDATE, DELETE, and DDL.
2. Prefer a replica if the primary is busy. Recall tables. Bind the channel column.
3. Ask one goal: Q2 refund rate by channel, paid orders as denominator, exclude test accounts.
4. Inspect SQL. Re-run after the note is corrected.

## Source and goal

| Field | Value |
|---|---|
| Sources | Read-only Postgres instance; 14 order-related tables; ~2.4 million paid-order rows |
| Standing goal | Q2 refund rate by channel, paid orders as denominator, exclude test accounts |
| Contrast | Guess schema vs read-only + note |

## Results

| Retrieval state | SELECT-only role issued | Channel note bound | SQL inspectable |
|---|---|---|---|
| Guess schema | 0 | 0 | 0 |
| Read-only + note | 1 | 1 | 1 |

Wall-clock for the successful role rerun: 10 minutes (warehouse time excluded). The clock started when the operator opened the standing goal and ended when the issued role, the bound note, and the inspectable SQL sat side by side.

## What you may cite

- Artifact counts 0/0/0 → 1/1/1, 14 tables + ~2.4M paid-order rows on this run, ~10 min wall-clock, run ID

## What you may not claim

- Customer uplift %, a faster mirror, official EEAT score, named-logo case, or that Stanford / NSF / EPA / PostgreSQL / DataCite / W3C / ISO / Gartner / WAIC scored this run

## Independent context (not this run)

- [PostgreSQL Privileges](https://www.postgresql.org/docs/current/ddl-priv.html) (retrieved 2026-08-29)
- [PostgreSQL GRANT](https://www.postgresql.org/docs/current/sql-grant.html) (retrieved 2026-08-29)
- [Stanford HAI AI Index](https://hai.stanford.edu/ai-index) (retrieved 2026-08-29)
- [NSF: About](https://www.nsf.gov/about) (retrieved 2026-08-29)
- [EPA data](https://www.epa.gov/data) (retrieved 2026-08-29)
- [NOAA: About our agency](https://www.noaa.gov/about-our-agency) (retrieved 2026-08-29)
- [NASA: About](https://www.nasa.gov/about/) (retrieved 2026-08-29)
- [ISO/IEC 9075](https://www.iso.org/standard/76583.html) (retrieved 2026-08-29)
- [W3C DCAT](https://www.w3.org/TR/vocab-dcat-3/) (retrieved 2026-08-29)
- [DataCite](https://datacite.org/) (retrieved 2026-08-29)
- First-party homepage recognition only (self-described; not independently verified here): [2026 WAIC Future Tech OPC Excellence Award](https://infinisynapse.com/#recognition)

## Machine-readable aggregate

- [aggregate-NMD-CPG-20260822.csv](./aggregate-NMD-CPG-20260822.csv)
- [verify-NMD-CPG-20260822.py](./verify-NMD-CPG-20260822.py)