How do you guys visualize your data on D1 apart from the view on the account dashboard? I’m asking because I’m running a local dev version with miniflare and sometimes I just don’t know what I have in the DB anymore. For now I have to run wrangler exec --local --file=statements.sql and keep doing manual selects to inspect what’s inside but I think it must be a better way to do this.
I know this is pretty late reply but for anyone coming to this, you can use https://dbgate.org/
just add a new connection > select sqlite and it will ask you to provide the path to the sqlite file.
if you are running locally you can locate in the .wrangler/state/v3/d1/miniflare-D1DatabaseObject
select the file with extension .sqlite
this will then auto populate the tables for you.
if you make a Cloudflare Workers project, you can find sqlite file in workers/.wrangler/state/v3/d1/miniflare-D1DatabaseObject/ directory.
We can visualize it using DB Client (such as DBeaver) !