For exploring grants data using SQL queries in Postgres
This is a NodeJS/typescript ETL framework, powered by the Allo indexer data API. This ETL pipeline queries the Allo indexer data API and populates the existing Postgres db in docker (see docker-compose.yml file). Database schema is managed using Prisma (a Typescript ORM).
-
Install Docker. Visit https://www.docker.com/ to install.
-
After Docker installation, open Terminal to this repo location and run:
docker compose up-
Once all containers are running and healthy, open
http://localhost:5555to open PGAdmin. -
Login using default login details:
Email: [email protected]
Password: admin
- Load and configure your server:
| Config Name | Value |
|---|---|
| Host name/address | host.docker.internal |
| Port | 5432 |
| Username | postgres |
| Password | postgres |
-
Once all containers are running and healthy, open
http://localhost:3000to open Metabase UI. -
Login using default login details:
Email: [email protected]
Password: password420
- Click on the Query tool (image below) and copy any sample query from
./queries😉
You can modify the schema file (located at ./prisma/schema.prisma) as needed. To kick off indexing for a particular chain, you can run:
yarn run etl --chain [chainId]Currently available chains are:
| Chain | ChainId |
|---|---|
| Ethereum Mainnet | 1 |
| Optimism Mainnet | 10 |
| Fantom Opera | 250 |
| Public Goods Network (PGN) | 424 |
For more hands-on use cases like creating a custom ETL pipeline like indexing data from the blockchain via RPC using tools like chainsauce.
You can be a cool anon and send in a PR. If you have an SQL query that has helped you and you feel will be helpful to other Anons 👻 and explorers 🔭, feel free to fork this, add it to ./queries, and send in a PR.