Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to see a SQLite database content with Visual Studio Code [closed]

I'm new to Django and try to see a SQLite3 file. I'm looking for a way to open and view a database content with visual studio code like Pycharm can do (see picture) Database content view in Pycharm

Does an extension could do that? Is it possible to achieve this in VSC?

like image 293
DEADBEEF Avatar asked Dec 06 '16 11:12

DEADBEEF


People also ask

How do I view the contents of a SQLite database?

Open a command prompt (cmd.exe) and 'cd' to the folder location of the SQL_SAFI. sqlite database file. run the command 'sqlite3' This should open the SQLite shell and present a screen similar to that below.

How can I see my database in VSCode?

Connect to your database In Visual Studio Code, press Ctrl+Shift+P (or F1) to open the Command Palette. Select MS SQL:Connect and choose Enter. Select Create Connection Profile.


1 Answers

I published an extension to query and explore sqlite3 databases

vscode-sqlite

like image 64
Alex Covizzi Avatar answered Sep 29 '22 01:09

Alex Covizzi