ENDA
P

PostgreSQL

by PostgreSQL

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

DatabaserGratisBasic-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 detaljerne hos udbyderen
Gratis — PostgreSQL is open-source and free to use. Cloud hosting may have costs.
Godkendelse
Basic-godkendelse
Kompatible noder
AgentResourceInputOutput
Hjemmeside
https://www.postgresql.org

Sæt PostgreSQL bag din AI-agent

Opsæt PostgreSQL sammen med dine andre værktøjer i planneren — uden kode — så AI kan bruge det for dine kunder.

Åbn planneren

Relaterede Databaser-værktøjer

M

MySQL

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

M

MongoDB

Connect to MongoDB databases to store, query, and manage document-based data

P

Pinecone

Upsert and query vector embeddings in Pinecone for retrieval-augmented generation (RAG), semantic search, and similarity matching in agent workflows.