Catapulta Auto Indexer

This project provides a REST and GraphQL API built with Elysia and Bun, designed to automate the indexing of smart contract events deployed by Catapulta users. It uses Rindexer for indexing and PostgreSQL as the database.

---

🚀 Features

• Automatic indexing of events from deployed contracts
• Query events by contract and event type
• Sorting support for event data
• Proxy to Rindexer's GraphQL service
• Add new contracts and dynamically restart the indexer
• Swagger documentation available at /docs

---

🧱 Architecture

• Backend: Bun + Elysia + Swagger
• Indexer: Rindexer
• Database: PostgreSQL
• Containers: Docker + DevContainers

---

🛠 Requirements

• Docker and Docker Compose
• VSCode with the Dev Containers extension

Important: create a .env file in the root directory with the necessary PostgreSQL and app variables:

POSTGRES_HOST=localhost
POSTGRES_PORT=5440
POSTGRES_USER=postgres
POSTGRES_PASSWORD=yourpassword
POSTGRES_DB=postgres

# Keys to interact with each network
INFURA_API_KEY=your_infura_key
...

---

🐳 Usage Instructions

1. Clone the repository and enter the project folder

git clone https://github.com/catapulta-sh/catapulta-auto-indexer.git
cd catapulta-auto-indexer

2. Open in VSCode and launch Dev Container

Select "Reopen in Container" when prompted by VSCode.

3. Start the services

docker compose up --build

This will launch:

• postgresql on port 5440
• app with Bun and Elysia on ports 3000 (REST) and 3001 (GraphQL)

---

🔌 Available Endpoints

REST

Method	Path	Description
GET	/event-list	Lists all event types indexed for a specific contract using composite key (contract_name + report_id)
GET	/events	Returns all events for a contract and specific event name, ordered by block number
POST	/graphql	Proxy to Rindexer's GraphQL service
POST	/add-contracts	Adds contracts to rindexer.yaml and restarts the indexer
GET	/	Basic test route (Hello Elysia)

Swagger

• Available at: http://localhost:3000/docs

---

📘 API Usage Examples

GET /event-list

GET /event-list?contract_name=MyContract&report_id=abc123

Response:

{
  "events": ["Transfer", "Approval", "Mint"],
  "indexer_id": "internal_id_123"
}

GET /events

GET /events?indexer_id=internal_id_123&event_name=Transfer&sort_order=-1

Response:

{
  "events": [
    {
      "block_number": 18500000,
      "log_index": 25,
      "transaction_hash": "0xabc123...",
      "from": "0x123...",
      "to": "0x456...",
      "value": "1000000000000000000"
    }
  ]
}

POST /graphql

{
  "query": "query { allTransfers(first: 5) { nodes { txHash value } } }"
}

POST /add-contracts

{
  "contracts": [
    {
      "name": "MyContract",
      "report_id": "abc123",
      "network": "ethereum",
      "address": "0xABC123...",
      "start_block": "20000000",
      "abi": [/* ABI JSON */]
    }
  ]
}

---

📁 Project Structure

├── .devcontainer
│   └── devcontainer.json
│   └── docker-compose-dev.yml
├── abis/
├── node_modules/
├── src/
│   └── index.ts
├── bun.lock
├── rindexer.yaml
├── Dockerfile
├── docker-compose.yml
├── package.json
├── tsconfig.json
├── .env
└── README.md

---

⚙️ Testing & Debugging

• Open http://localhost:3000/docs to test endpoints with Swagger UI.
• Use tools like Postman or curl for manual testing.
• The rindexer process restarts automatically whenever a new contract is added.

---

📄 License

MIT © Catapulta Labs