Show HN: SQLite Online – 11 years of solo development, 11K daily users

I immediately tried to run .schema and a syntax error was returned.

I assume this is because sqliteonline is using the sqlite library, not running the literal sqlite command line application. Per item 7 in the faq (https://sqlite.org/faq.html), the way to get that info would be to run something like the following:

SELECT * FROM sqlite_schema WHERE type='table' ORDER BY name;

The website does seem to correctly return the names/schemas of whatever tables you've created if you run the command above, but the editor (incorrectly) adds red squigglies around the command, since I guess it doesn't realize this is allowed.