AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents
TypeScript ai-agentai-agent-toolsai-agentsai-agents-frameworkmcpmcp-servermcp-toolsmcpsn8n-alternativeno-code-automationworkflowworkflow-automationworkflows
import { createAction, Property } from '@activepieces/pieces-framework';
import { postgresAuth } from '../auth';
import { pgClient, postgresCommon, postgresUtils } from '../common';
import { insertRowOutputSchema } from '../output-schemas';
export const insertRow = createAction({
auth: postgresAuth,
name: 'insert-row',
classification: 'WRITE',
displayName: 'Insert Row',
description: 'Inserts a new row into a table',
audience: 'both',
outputSchema: insertRowOutputSchema,
aiMetadata: {
description: 'Inserts a single row into a PostgreSQL table from a map of column names to values, and by default returns the inserted row as stored by the database (including defaults and generated ids). Use to add a record. Turn off Return Inserted Row when the connection only has INSERT permission, since returning the row also needs SELECT. Not idempotent: each call performs a fresh INSERT, so repeating it adds duplicate rows or errors on a unique-key collision.',
idempotent: false,
},
propertyGroups: [
{
key: 'row',
display: 'section',
label: 'Row to insert',
icon: 'inbox',
props: ['table', 'values'],
},
],
props: {
table: postgresCommon.table,
values: Property.Object({
displayName: 'Values',
description: 'Column names mapped to the values to insert.',
required: true,
}),
return_row: Property.Checkbox({
displayName: 'Return Inserted Row',
description: 'Return the stored row with generated ids. Needs SELECT permission too.',
required: false,
advanced: true,
defaultValue: true,
}),
},
async run(context) {
const { table, values, return_row } = context.propsValue;
const columns = Object.keys(values);
if (columns.length === 0) {
throw new Error('Values must contain at least one column.');
}
const quotedColumns = columns.map((column) => postgresUtils.quoteIdentifier(column)).join(', ');
const placeholders = columns.map((_, index) => `$${index + 1}`).join(', ');
const query = `INSERT INTO ${postgresUtils.qualifiedName(table)} (${quotedColumns}) VALUES (${placeholders})${return_row === false ? '' : ' RETURNING *'}`;
const client = await pgClient(context.auth);
try {
const result = await client.query(query, columns.map((column) => values[column]));
return {
row: result.rows[0] ?? null,
rowCount: result.rowCount,
};
} finally {
await client.end();
}
},
});