---
title: "Databases"
description: "Overview of all databases supported by SQL Studio."
canonical_url: "https://docs-cloud-kinfe123-sqlite-studio.farming-labs.dev/docs/databases"
markdown_url: "https://docs-cloud-kinfe123-sqlite-studio.farming-labs.dev/docs/databases.md"
last_updated: "2018-10-20"
---

# Databases
URL: /docs/databases
LLM index: /llms.txt
Description: Overview of all databases supported by SQL Studio.

# Databases

SQL Studio supports a wide range of SQL databases and file formats. Each database has its own subcommand with specific arguments. Global options like `--address` and `--timeout` go before the subcommand; database arguments go after it.

```bash
sql-studio [OPTIONS] <SUBCOMMAND> [ARGS...]
```

## Supported Databases

| Database | Subcommand | Type |
|----------|------------|------|
| SQLite | `sqlite` | Local file |
| libSQL | `libsql` | Remote server |
| Local libSQL | `local-libsql` | Local file (libSQL driver) |
| PostgreSQL | `postgres` | Remote server |
| MySQL / MariaDB | `mysql` | Remote server |
| DuckDB | `duckdb` | Local file |
| Parquet | `parquet` | Local file |
| CSV | `csv` | Local file |
| ClickHouse | `clickhouse` | Remote server |
| Microsoft SQL Server | `mssql` | Remote server |

> **Note:** DuckDB, Parquet, and CSV all depend on the DuckDB native library. They are not available in the musl (static Linux) build. Use the glibc Linux build, macOS, or Windows for those formats.

For global CLI options that apply to every subcommand, see [Configuration](/docs/configuration).

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