---
title: "Features"
description: "Explore the SQL Studio user interface."
canonical_url: "https://kinfe123-sqlite-studio-docs-cloud-adh5vh1cz-farming-labs.vercel.app/docs/features"
markdown_url: "https://kinfe123-sqlite-studio-docs-cloud-adh5vh1cz-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.

**Overview Dashboard** shows database metadata and statistics — the file path or connection URL, server version, database size, and a summary of tables, indexes, triggers, and views. Bar charts break down row counts, column counts, and index counts per table at a glance.

**Table Explorer** lists every table with its row count. Select a table to see its column definitions, constraints, creation SQL, and a paginated data grid with infinite scroll.

**Query Editor** gives you a Monaco-powered SQL editor — the same editor that powers VS Code — with syntax highlighting and IntelliSense autocomplete sourced from your live database schema. Write a query and run it with a button click or keyboard shortcut.

**ERD Viewer** renders an interactive entity-relationship diagram with tables as nodes and foreign-key relationships as edges. You can pan, zoom, and drag nodes to arrange the diagram however makes sense for your schema.

## 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).