> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dbpilot.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Explore Data

To view a table's or view's data:

1. Make sure you have selected the "Entities" tab
2. Click on the table/view you want to explore
3. Use the next "Previous" / "Next" buttons to navigate through rows
4. Optionally, [search for specific rows using filters](#filters)

<img src="https://mintlify.s3.us-west-1.amazonaws.com/dbpilot/resources/explore.png" alt="Explore data" className="blog-image" />

Additionally, you can right click an entity name in the sidebar for options to open a new tab for the entity, create a new SQL query for the entity, or copy the entity's SQL identifier:

<img src="https://mintlify.s3.us-west-1.amazonaws.com/dbpilot/resources/table-right-click.png" alt="Entity right click menu" className="blog-image-sm" />

## Filters

To filter the data of a table:

1. First select a table.
2. Then click the "Filters" button to reveal the filters UI.

<img src="https://mintlify.s3.us-west-1.amazonaws.com/dbpilot/resources/filters-hidden.png" alt="Filters" className="blog-image" />

Now you can:

1. Select which column to filter on
2. Select which comparitor to use (`=`, `<`, `>`, `LIKE`, etc.)
3. Define for which value to filter
4. Apply/Unapply the filter by clicking the "Apply" / "Applied" button
5. Optionally, add additional filters or remove filters using the minus and plus buttons. Multiple filters will be combined using `AND`.

<img src="https://mintlify.s3.us-west-1.amazonaws.com/dbpilot/resources/filters-revealed.png" alt="Filters" className="blog-image" />