> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sqd.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# CLI Cheatsheet

> Quick reference for commonly used Squid CLI commands

This guide provides a quick reference to the commands needed to launch the squid and manage the database.

## Initial Setup

Before running the squid, install all project dependencies:

```bash theme={"system"}
npm i
```

## Compiling the Project

```bash theme={"system"}
npx tsc
```

## Running the Squid

Start a local PostgreSQL database to store the data (the template includes a Docker Compose file):

```bash theme={"system"}
docker compose up -d
```

Apply database migrations to create the target schema:

```bash theme={"system"}
npx squid-typeorm-migration apply
```

For detailed information on migrations, see [TypeORM Migration generation](../../reference/typeorm-migration).

Run the indexer:

```bash theme={"system"}
node -r dotenv/config lib/main.js
```

<Note>
  You can use the `sqd` utility to shorten these commands and manage their
  interrelations — see [commands.json](/en/cloud/reference/cli/commands-json).
</Note>

## Next Steps

<CardGroup cols={2}>
  <Card title="Development Flow" icon="diagram-project" href="../../design">
    Learn the general development workflow
  </Card>

  <Card title="Full CLI Reference" icon="book" href="/en/cloud/reference/cli/installation">
    Complete CLI documentation
  </Card>
</CardGroup>