---
layout: article
title: Databases
description: Store and query app data with Appwrite Databases. Use TablesDB, DocumentsDB, and VectorsDB, or host managed PostgreSQL and MySQL with direct SQL access.
---

Appwrite Databases provide performant and scalable storage for your application, business, and user data. Choose the database that fits your use case, from managed APIs with permissions and realtime to dedicated native engines you connect to directly.

**Looking for file storage?**

Databases store data. If you need to store files like images, PDFs, or videos, use [Appwrite Storage](/docs/products/storage).

# Appwrite databases

Managed databases with an Appwrite API on top, including permissions, indexes, queries, and realtime. Available on shared and dedicated infrastructure.

- [TablesDB](/docs/products/databases/tablesdb): Structured, relational data with typed columns, rows, relationships, and indexes.
- [DocumentsDB](/docs/products/databases/documentsdb): Schemaless document storage for flexible, JSON-style data.
- [VectorsDB](/docs/products/databases/vectorsdb): Store embeddings and run similarity search to power AI features.

# Shared and dedicated databases

An Appwrite database runs either on a shared pool that Appwrite manages for you, or on compute provisioned for your project alone.

If you leave `specification` out when creating a database, it lands on the shared pool and is ready to use as soon as the call returns. If you pass a specification, Appwrite provisions a dedicated database on that tier, which you can then resize, replicate, and fail over. Collections and rows or documents work through the same methods either way.

# Native databases

Native database engines provisioned for your project with direct connection access and no abstraction layer. Available on dedicated infrastructure.

- [Managed PostgreSQL](/docs/products/databases/postgresql): Hosted PostgreSQL with direct connections, backups, pgvector, and full SQL.
- [MySQL](/docs/products/databases/mysql): A dedicated, native MySQL database you connect to directly.