If you don’t have access yet, subscribe at neynar.com
If you give chatgpt the table schema (i.e. column names and data types) and tell it what you want, it’ll write the sql query for you!
- Query any Farcaster data in the playground
- SQL access is also available over API, check your Redash profile for your API key. This is a separate API key for SQL only (not the same key as our read and write APIs)
- Documentation on how to use SQL over API is here
Data is more raw compared to our APIs, please let us know if any particular views would be useful; we encourage API use instead of SQL if you’re building clients. You will likely need to join different tables when using SQL.
links table has follower <> follow data:
reaction_type1 is “like” and 2 is “recast” in the
hashin the reactions table is the “reaction hash” and
target_hashis the hash of the cast that received the reaction
Updated 13 days ago