running none SQL commands in SQLite?


I am evaluating DataGrip right now to use with SQLite.  There are times the program needs to run raw non SQL commands, such as PRAGMA <...> or maybe .schema [tablename], I would like to see the output the database will provide, is there a way to execute these commands in DataGrid?



You just need to execute your queries in Console:


So what I am doing is entering the command in this window and then I click on the green arrow.  Then it gives me the error "Nothing to run", what am I doing wrong?


IDE supports PRAGMA commands, but do not support sqlite3 (dot-commands).

As a workaround you can use sqlite3 CLI in Terminal:


Please sign in to leave a comment.