My schemas are pretty simple, but I actually use the code presented in the first post of this thread for creating them (actually an older version of the code above).

For spelunking tables and recordsets, I actually use the SQLite Manager addon for Firefox...it isn't great, but it is within a few keystrokes of the browser I spend much of time using