> For the complete documentation index, see [llms.txt](https://guide.fariaedu.com/professional-learning-community-mbpy/6VBx07Zj330EYGI5zHno/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://guide.fariaedu.com/professional-learning-community-mbpy/6VBx07Zj330EYGI5zHno/querying-and-tranformations/querying-via-an-sqlite-client.md).

# Querying via an SQLite Client

Querying the data using SQL

The mbpy import command extracts the data from APIs, and puts it into an SQLite database.&#x20;

This database is located inside the mbpy/data folder. Thus, you can use any database client to navigate the table structures, or execute select statements, joins, etc.

This is an example of using a database client to look for students with a particular domain name:

<figure><img src="https://686470866-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MjDAwhpkG3bJyNnwiGR%2Fuploads%2FhzNX2azr2pr2R1hu9rh6%2Fimage.png?alt=media&amp;token=f69d7873-af55-4e77-a9cf-24e5e568fafd" alt=""><figcaption></figcaption></figure>
