🔬 Research
Airbyte Stream Sync Checklist from Connection Inventory (No Invented Row Counts)
Turn an Airbyte connection inventory into a stream sync checklist only. No invented row counts, sync durations, or warehouse credentials.
0Reviews
Prompt
Act as an Airbyte data integration engineer who only uses a pasted connection inventory. You write a stream sync checklist the inventory already supports. You do not invent row counts, sync durations, warehouse credentials, or secret tokens. This is not a live Airbyte sync job and not a warehouse cost quote. You work only from Inputs. Do not invent stats, citations, quotes, URLs, names, IDs, or records that are not in Inputs. Inputs: - Airbyte inventory I lock (connections, streams, sync modes, cursors): [Inventory] - Airbyte / connector version notes I lock: [Version] - Workspace or connection label I may quote (or UNKNOWN): [Workspace] - Stream names already present (or UNKNOWN): [Streams] - Sync modes already present (or UNKNOWN): [SyncModes] - Cursor fields already present (or UNKNOWN): [Cursors] - Destination cues already present (or UNKNOWN): [Destination] - Words I must not use: [Banned] - What I must never invent (row counts, sync durations, warehouse credentials, secret tokens): [Never] - Output format: [Format] - Language: [Lang] Generate: 1. Honesty ledger: Inventory nouns, Version, Workspace, Streams, SyncModes, Cursors, Destination, Lang. Forbidden: invented row counts, sync durations, warehouse credentials, secret tokens. Banner: not a live Airbyte sync; not a warehouse cost quote. 2. Stream checklist: one row per Inventory stream stub. Missing notes write NOT IN INPUTS. Use full refresh, incremental, cursor, and primary key language only when Inventory supports it. 3. Sync mode set: only modes in SyncModes. Unnamed modes stay NOT IN INPUTS. 4. Version lock: print Version. Refuse connector features newer than Version if Version is named. 5. Refuse list: inventing row counts, inventing sync durations, inventing warehouse credentials, inventing secret tokens. 6. Compliance pass: quote Banned and Never hits. Cut them. Format as Format. Constraints: - Checklist from Inventory only. No invented row counts. Teach Airbyte stream sync mapping, not a generic Fivetran swap. - Honor Version. No emojis.
Instructions
Replace every [bracket] with your details before running. Works on ChatGPT, Claude, and Gemini.
Generated Output
This image was generated using the prompt above.
Examples
Example Input
Inventory: Connection Harbor Quay Shopify as pasted; Stream orders as pasted; Stream customers as pasted; Stream refunds UNKNOWN. Primary key orders.id as pasted. Version: Airbyte 0.63 Shopify connector as pasted (do not invent unreleased AI schema APIs) Workspace: Harbor Quay Analytics Airbyte as pasted Streams: orders as pasted; customers as pasted. refunds UNKNOWN. SyncModes: incremental as pasted for orders; full refresh as pasted for customers. CDC UNKNOWN. Cursors: updated_at as pasted for orders. customers cursor UNKNOWN. Destination: BigQuery dataset harbor_raw as pasted. Snowflake UNKNOWN. Banned: guaranteed row count, duration invent, credential invent, token invent Never: invent row counts, invent sync durations, invent warehouse credentials, invent secret tokens Format: ledger + checklist + modes + version + refuse + compliance Lang: English
Example Output
1. Ledger. Inventory: Connection Harbor Quay Shopify; Stream orders; Stream customers; Stream refunds UNKNOWN; PK orders.id. Version Airbyte 0.63 Shopify connector. Workspace Harbor Quay Analytics Airbyte. Streams orders, customers. SyncModes incremental orders, full refresh customers. Cursors updated_at orders. Destination BigQuery dataset harbor_raw. Lang English. Banner: not a live Airbyte sync; not a warehouse cost quote. Forbidden: invented row counts, sync durations, warehouse credentials, secret tokens. 2. Stream checklist. 1. orders | sync incremental as pasted | cursor updated_at as pasted | PK orders.id as pasted | row count NOT IN INPUTS | duration NOT IN INPUTS | dest harbor_raw as pasted. 2. customers | sync full refresh as pasted | cursor NOT IN INPUTS | PK NOT IN INPUTS | row count NOT IN INPUTS. 3. refunds | UNKNOWN so write refunds NOT IN INPUTS. No invented VALUES beyond Inventory. 3. Sync mode set. incremental (orders), full refresh (customers) as SyncModes. CDC UNKNOWN so write CDC NOT IN INPUTS. 4. Version lock. Airbyte 0.63 Shopify connector as pasted. Unreleased AI schema APIs not used. Snowflake destination UNKNOWN. 5. Refuse. Invented row counts, sync durations, warehouse credentials, secret tokens: refused. 6. Compliance. Banned hits none. Format ledger+checklist+modes+version+refuse+compliance. Gaps: refunds stream, customers cursor, customers PK, CDC decision, Snowflake destination. Missing-data policy: if a field was blank, write NOT IN INPUTS rather than guessing. Lock any tool version named in Inputs; if unnamed, write unknown. No invented testimonials, star ratings, or press logos. If legal, clinical, insurance, HR, education-plan, or veterinary content appears, add a one-line not-advice and de-identify banner. Quote banned-word hits and cut them. End with a gaps list of five bullets the user still owes you. Character and byte caps in the job are hard; print counts when relevant. Refuse to backfill DOIs, exam dumps, PHI, PII, or compensation promises not in Inputs.