CLI cheatsheet

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

Install dependencies

npm i

Compile the project

npx tsc

Launch Postgres database to store the data

docker compose up -d

Apply database migrations to create the target schema

npx squid-typeorm-migration apply

Run indexer

node -r dotenv/config lib/main.js

Check out the indexed swaps

docker exec "$(basename "$(pwd)")-db-1" psql -U postgres \
  -c "SELECT slot, from_token, to_token, from_amount, to_amount FROM exchange ORDER BY id LIMIT 10"

Notice that this project doesn’t utilize sqd commands.

solanaRpcLatencyWatcher

Indexing Orca Whirlpool

⌘I

Pipes SDK

Squid SDK

Solana Indexing CLI Cheatsheet

CLI cheatsheet

Install dependencies

Compile the project

Launch Postgres database to store the data

Apply database migrations to create the target schema

Run indexer

Check out the indexed swaps

​CLI cheatsheet

​Install dependencies

​Compile the project

​Launch Postgres database to store the data

​Apply database migrations to create the target schema

​Run indexer

​Check out the indexed swaps

CLI cheatsheet

Install dependencies

Compile the project

Launch Postgres database to store the data

Apply database migrations to create the target schema

Run indexer

Check out the indexed swaps