Connect PyCharm to SQLite on Windows

Posted by in Software

To connect to a SQLite database on PyCharm you have two options:

  1. Manual connection and
  2. Automatic connection.

Manual connection

Use the following steps to perform the manual connection:

  1. Open the Database tab in PyCharm (usually on the right hand side)
  2. Right-click and select the New > Data Source option in the menu. A dialog box will pop up:
    Setting pycharm DB connection on windows

    Setting pycharm DB connection on windows

  3. Select the SQLite driver (download it if necessary)
  4. Add the Database URL like jdbc:sqlite:<absolute path to your db file>/db.sqlite

    A concrete example would be:

The automatic way

This way is simpler:

  1. Open the Database tab in PyCharm
  2. Locate the database file in the Project explorer (or in Windows Explorer)
  3. Drag and drop it in the Database tab

This should work easily. If it doesn’t, ti means you don’t have the drivers installed and you need to go to the Manual method above and install the driver.


A little experiment: If you find this post and ad below useful, please check the ad out :-)