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

Connecting to SQLite

Note: PopSQL supports SQLite only as a direct connection.

  1. Open the connections page in preferences, see managing connections for more information.
  2. Click the Add new Connection button at the top of the connections page.
  3. Select SQLite from the list.
  4. Give a Connection name for your own internal reference.
  5. For Database, click Choose a File and then select the database 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?