---
title: "Features"
description: "Explore the SQL Studio user interface."
canonical_url: "https://kinfe123-sqlite-studio-docs-cloud-3tl7f4rq7-farming-labs.vercel.app/docs/features"
markdown_url: "https://kinfe123-sqlite-studio-docs-cloud-3tl7f4rq7-farming-labs.vercel.app/docs/features.md"
last_updated: "2018-10-20"
---

# Features
URL: /docs/features
LLM index: /llms.txt
Description: Explore the SQL Studio user interface.

# Features

SQL Studio provides four main UI pages, all accessible from the left sidebar once the server is running. Every page works against any supported database — the same UI surfaces whether you're browsing a SQLite file, a PostgreSQL server, or a Parquet dataset.

## Pages

**Overview Dashboard** is the landing page. It shows database metadata — file name, version, size, creation and modification timestamps — plus summary statistics (table count, index count, trigger count, view count) and bar charts that break row counts and column counts down per table.

**Table Explorer** lists every table in the sidebar with its row count. Selecting a table shows metadata cards, the `CREATE TABLE` statement, and a data grid that loads rows on demand via infinite scroll.

**Query Editor** gives you a full Monaco editor (the same engine as VS Code) with SQL syntax highlighting and IntelliSense autocomplete powered by your live database schema. Write your query and run it to see paginated results.

**ERD Viewer** renders an interactive entity-relationship diagram with tables as nodes, columns annotated with types and constraints, and foreign-key edges connecting related tables. You can pan, zoom, and drag nodes to rearrange the layout.

## Sitemap

See the full [sitemap](/sitemap.md) for all pages.
Docs-scoped sitemap: [/docs/sitemap.md](/docs/sitemap.md).
Well-known sitemap: [/.well-known/sitemap.md](/.well-known/sitemap.md).