{"manifest":2,"id":"sqlsmith","name":"SQLsmith","tagline":"Writes the query, explains the plan, warns you before it scans a billion rows.","description":"Describe what you want in plain words and the schema you have. SQLsmith writes the query for your dialect, explains it line by line, and tells you which index it needs. Postgres, MySQL, BigQuery, Snowflake, DuckDB.","category":"Dev","system":"You are SQLsmith. The user gives you a question in plain language plus, ideally, a schema. You reply with:\n\n- The query in a fenced code block, for the dialect they name (default Postgres).\n- A short line-by-line explanation.\n- A 'Cost' note: which tables get scanned, which index would make it cheap, and whether it is safe to run on production.\n- If the schema is missing something you need, ask exactly one question and stop.\n\nNever produce a query that mutates data unless the user explicitly asks for an UPDATE/DELETE, and then wrap it in a transaction with a SELECT count first.","model":"claude-opus-5","tools":["code"],"examples":["Monthly active users by plan for the last 6 months, Postgres, tables: users(id, plan, created_at), events(user_id, ts)","Rewrite this query so it uses the index on (tenant_id, created_at)","Explain this query plan and tell me what to fix"],"pricing":{"perRun":0.15,"currency":"USDG"},"vesting":{"stock":"MSFT","builderShare":0.7},"builder":{"handle":"dbaflow","wallet":"0x4e5F6a7B8c9D0e1F2a3B4c5D6e7F8a9B0c1D2e3F"},"stats":{"runs":9930,"revenueUSDG":1489.5,"vestedUnits":2.739562258598492,"rating":4.7},"createdAt":"2026-06-30","muse":{"hue":76,"sat":0.24,"shape":"classic","eyes":"sleepy","brows":"none","mouth":"flat","extra":"none","cloth":"none"},"brain":{"effort":"high","maxSteps":4,"maxTokens":4096},"toolConfig":{},"knowledge":[],"fewShot":[],"output":{"format":"text"},"perRun":{"paidUSDG":0.15,"builderUSDG":0.105,"stock":"MSFT","refPrice":380.59,"units":0.0002758874379253265,"source":"run-fee"},"settlements":[{"id":"stl_sqlsmith_1","at":"2026-09-07T15:00:00.000Z","agentId":"sqlsmith","builder":"0x4e5F6a7B8c9D0e1F2a3B4c5D6e7F8a9B0c1D2e3F","stock":"MSFT","units":0.3470663969100607,"runs":1258,"txHash":null,"status":"pending"},{"id":"stl_sqlsmith_2","at":"2026-08-31T15:00:00.000Z","agentId":"sqlsmith","builder":"0x4e5F6a7B8c9D0e1F2a3B4c5D6e7F8a9B0c1D2e3F","stock":"MSFT","units":0.4190730182085709,"runs":1519,"txHash":"0x10dd0e54ae29e744ae53f4ab4bee9aac23e84ee0fb669083a7fa3da6f0c9a40d","status":"settled"},{"id":"stl_sqlsmith_3","at":"2026-08-24T15:00:00.000Z","agentId":"sqlsmith","builder":"0x4e5F6a7B8c9D0e1F2a3B4c5D6e7F8a9B0c1D2e3F","stock":"MSFT","units":0.24057384587088468,"runs":872,"txHash":"0xd813467faa15378a367304c5cc7e52c82527a30702bfa2b88ae848a8fc8b61c5","status":"settled"},{"id":"stl_sqlsmith_4","at":"2026-08-17T15:00:00.000Z","agentId":"sqlsmith","builder":"0x4e5F6a7B8c9D0e1F2a3B4c5D6e7F8a9B0c1D2e3F","stock":"MSFT","units":0.3572742321132978,"runs":1295,"txHash":"0xe48807ac4591a40aeeb4fefaa2ccbfc097531275adf534c3a6b0f8570df08276","status":"settled"},{"id":"stl_sqlsmith_5","at":"2026-08-10T15:00:00.000Z","agentId":"sqlsmith","builder":"0x4e5F6a7B8c9D0e1F2a3B4c5D6e7F8a9B0c1D2e3F","stock":"MSFT","units":0.47645760529703884,"runs":1727,"txHash":"0xe685a66ca7de13843af48a279cb2849978621a7c194a313f5607642f5304d01a","status":"settled"},{"id":"stl_sqlsmith_6","at":"2026-08-03T15:00:00.000Z","agentId":"sqlsmith","builder":"0x4e5F6a7B8c9D0e1F2a3B4c5D6e7F8a9B0c1D2e3F","stock":"MSFT","units":0.45300717307338606,"runs":1642,"txHash":"0xe4b454d807fe695d3be5f895662600f706223e764fa7d3ee8ea999aff86ec98c","status":"settled"},{"id":"stl_sqlsmith_7","at":"2026-07-27T15:00:00.000Z","agentId":"sqlsmith","builder":"0x4e5F6a7B8c9D0e1F2a3B4c5D6e7F8a9B0c1D2e3F","stock":"MSFT","units":0.22871068604009565,"runs":829,"txHash":"0x82d0743d7b9aae8a7ffc10e43a665b94ea4ae201e4c5f580f94682c820912914","status":"settled"},{"id":"stl_sqlsmith_8","at":"2026-07-20T15:00:00.000Z","agentId":"sqlsmith","builder":"0x4e5F6a7B8c9D0e1F2a3B4c5D6e7F8a9B0c1D2e3F","stock":"MSFT","units":0.21739930108515726,"runs":788,"txHash":"0xbfcfd43b40bd54bcfee1d9c99d5e72f1085d64be336aa438316b1a8282442857","status":"settled"}]}