llms.txt
Compare with other sites' llms.txt files →# Fakebase Studio
> The Postgres studio built for developers who move fast. Explore schemas, manage your tables, and seed them with data that fits your structure, and ship with confidence.
## Docs
- [Overview](https://fakebase.studio/docs): Guides for connecting Fakebase, exploring schema, editing tables, applying migrations, and building with agents.
- [Get started](https://fakebase.studio/docs/get-started.md): Install the Fakebase CLI to run a local PostgreSQL database with migrations, and download Fakebase Studio to work with it on macOS.
- [Build with Agents](https://fakebase.studio/docs/build-with-agents.md): Set up Cursor, Claude Code, or Codex to change your database for you with the Fakebase CLI.
## CLI
- [Overview](https://fakebase.studio/docs/cli.md): The Fakebase CLI runs a local PostgreSQL database for your project and manages its schema with plain-SQL migrations.
- [Install](https://fakebase.studio/docs/cli-install.md): Install the Fakebase CLI with npm, or run it with npx without installing.
- [Database](https://fakebase.studio/docs/cli-database.md): Set up a project, run its local PostgreSQL database, and connect your app with the Fakebase CLI.
- [Migrations](https://fakebase.studio/docs/cli-migrations.md): Create, check, and apply plain-SQL migrations with the Fakebase CLI.
## Studio
- [Overview](https://fakebase.studio/docs/studio.md): Fakebase Studio is the desktop app for working with your PostgreSQL database on macOS.
- [Databases](https://fakebase.studio/docs/studio-databases.md): Create a project, open a project folder, add a connection, and switch, rename, or burn databases in Fakebase Studio.
- [Tables](https://fakebase.studio/docs/studio-tables.md): Create, rename, and delete tables, and manage their columns and foreign keys in Fakebase Studio.
- [Data](https://fakebase.studio/docs/studio-data.md): Browse, insert, edit, and delete table rows in Fakebase Studio.
- [Schema](https://fakebase.studio/docs/studio-schema.md): See every table and the foreign keys between them as a diagram in Fakebase Studio.
- [Indexes](https://fakebase.studio/docs/studio-indexes.md): Look through every index in your database, how big it is, and how often it's used in Fakebase Studio.
- [SQL editor](https://fakebase.studio/docs/studio-sql-editor.md): Write and run SQL, see the results, and keep the queries you use in Fakebase Studio.
### Migrations
- [Migrations](https://fakebase.studio/docs/migrations.md): Keep schema changes as SQL files in your repo, in sync with the database you have open.
- [Apply and review](https://fakebase.studio/docs/apply-migrations.md): Review a pending migration and apply it to the database.
- [Schema drift](https://fakebase.studio/docs/schema-drift.md): Capture schema changes that already landed in the database as a migration file.
- [Manage history](https://fakebase.studio/docs/manage-migration-history.md): Restore, bundle, delete, and relink migrations in Fakebase Studio.