Introducing PopSQL + dbt. The first SQL editor with built-in dbt support.Read more →

Connecting to SQLite

  1. Click Manage Connections in the top center of the app.
  2. Click New Connection in the Manage Connections modal in PopSQL. alt text
  3. For Nickname, enter something a descriptive name for your connection, like Acme Production.
  4. For Type, choose SQLite.
  5. For Database, click Choose a File and then select the .db file on your local machine to which you want to connect.
  6. Hit Connect and you're all set! alt text

Happy querying! 🍭

Ready for a modern SQL editor?