# SQLite > Part of Prisma's Data Guide. The complete index is at https://www.prisma.io/dataguide/llms.txt. Canonical URL: https://www.prisma.io/dataguide/sqlite Content revision: 91b5ea3b95a0824bcd0e0d61f68d6121c6e45039fde2b5f874c4c65eec29030e Source revision: b6716699f6439c3ba6ae3bf7116b7da84963c978 ## Overview SQLite is a collection of a library, file format, and command line utility that provides self-contained relational database capabilities in local environments. Learn how to care for your application's data using SQLite's versatile, reliable data management capabilities. ## In this section - [Setting up a local SQLite database](https://www.prisma.io/dataguide/sqlite/setting-up-a-local-sqlite-database.md) - [Importing and exporting data in SQLite](https://www.prisma.io/dataguide/sqlite/importing-and-exporting-data-in-sqlite.md) - [Creating and deleting databases and tables with SQLite](https://www.prisma.io/dataguide/sqlite/creating-and-deleting-databases-and-tables.md) - [Inserting and deleting data with SQLite](https://www.prisma.io/dataguide/sqlite/inserting-and-deleting-data.md) - [How to perform basic queries with \`SELECT\` with SQLite](https://www.prisma.io/dataguide/sqlite/basic-select.md) - [How to update existing data with SQLite](https://www.prisma.io/dataguide/sqlite/update-data.md) - [How to export database and table schemas in SQLite](https://www.prisma.io/dataguide/sqlite/exporting-schemas.md)