Agentic Service Discovery

Resources

P

PostgreSQL

by PostgreSQL

Connect to PostgreSQL databases to query, insert, update, and manage data

DatabaserGratisGrundlæggende godkendelsedatabasesqldatastoragerelationalpostgres

Sådan bruger agenter PostgreSQL

  • Agent queries a table to look up user data, order history, or records before making a decision
  • Agent inserts a new row to persist the result, output, or event generated by a workflow step
  • Agent updates a record status or field after completing a task in the workflow
  • Agent runs a SQL query to aggregate or filter data needed as input to a downstream reasoning step
  • Agent uses the database as the authoritative state store for long-running multi-step workflows

Agenthandlinger

Execute QueryExecute a SELECT query and return results

Input: query, parameters

Returnerer: rows, rowCount, fields

Insert DataInsert new records into a table

Input: table, data, returning

Returnerer: rows, rowCount

Update DataUpdate existing records in a table

Input: query, parameters, returning

Returnerer: rows, rowCount

Delete DataDelete records from a table

Input: query, parameters, returning

Returnerer: rows, rowCount

Execute TransactionExecute multiple queries in a transaction

Input: queries

Returnerer: results, success

Execute FunctionCall a PostgreSQL function

Input: function, parameters

Returnerer: result

Get Table SchemaRetrieve table structure and column information

Input: table, schema

Returnerer: columns, primaryKey, indexes, constraints

Bulk InsertInsert multiple records efficiently using COPY or batch INSERT

Input: table, data, batchSize

Returnerer: totalInserted, batches

Execute Raw SQLExecute any SQL statement (DDL, DML, etc.)

Input: sql, parameters

Returnerer: rows, rowCount, command

Upsert DataInsert or update data using ON CONFLICT (PostgreSQL specific)

Input: table, data, conflictTarget, updateColumns

Returnerer: rowCount

Eksempel på workflows

1

User management system

Query and manage user data in PostgreSQL

2

Analytics data warehouse

Store and query analytics data with JSON support

3

Microservices data layer

Transactional data management for microservices

Om PostgreSQL

Leverandør
PostgreSQL
Pris Tjek altid detaljer med udbyderen
GratisPostgreSQL is open-source and free to use. Cloud hosting may have costs.
Godkendelse
Grundlæggende godkendelse
Kompatible noder
AgentResourceInputOutput

Byg et AI-workflow med PostgreSQL

Brug Agentic Planner til at designe, visualisere og forbinde PostgreSQL med dine andre værktøjer.

Åbn Agentic Planner

Relaterede Databaser-værktøjer