Connect PostgreSQL to Blockscout

Both apps 27PostgreSQL 10Blockscout 17

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected PostgreSQL database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected PostgreSQL database.

• Action
  Add Row

  Adds a new row.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Finds a row in a table via a lookup column.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected PostgreSQL database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected PostgreSQL database and returns the first row it matches.

• Action
  Update Row

  Updates an existing row.

• Action
  Find items by search

  Search across addresses, blocks, transactions, and tokens by query string. GET /search?q={query}

• Action
  Get address

  Get detailed info about an address or contract (balance, type, etc). GET /addresses/{address_hash}

• Action
  Get block

  Get detailed information about a block by number or hash. GET /blocks/{block_number_or_hash}

• Action
  Get smart contract

  Get verified smart contract source, ABI, and metadata by address. GET /smart-contracts/{address_hash}

• Action
  Get stats counters

  Get network-wide statistics (total blocks, transactions, addresses, gas price, etc). GET /stats

• Action
  Get token

  Get info about a token (ERC-20/721/1155) by contract address. GET /tokens/{address_hash}

• Action
  Get token instance

  Get detailed info about a specific NFT instance. GET /tokens/{address_hash}/instances/{id}

• Action
  Get transaction

  Get detailed information about a specific transaction by hash. GET /transactions/{transaction_hash}

• Action
  List address NFTs

  List NFTs owned by a specific address. GET /addresses/{address_hash}/nft

• Action
  List address token balances

  List all token balances held by a specific address. GET /addresses/{address_hash}/token-balances

• Action
  List address token transfers

  List token transfers involving a specific address. GET /addresses/{address_hash}/token-transfers

• Action
  List address transactions

  List transactions involving a specific address. GET /addresses/{address_hash}/transactions

• Action
  List blocks

  List recent blocks on the chain. GET /blocks

• Action
  List smart contracts

  List verified smart contracts. GET /smart-contracts

• Action
  List token holders

  List holders of a given token. GET /tokens/{address_hash}/holders

• Action
  List token transfers

  List transfers of a given token. GET /tokens/{address_hash}/transfers

• Action
  List transactions

  List recent transactions on the chain. GET /transactions

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.