通过 Aident Loadout 使用 Prisma Tools 的 Prisma Execute Sql Command。执行前查看输入、输出、设置、价格和风险。
Execute SQL commands that modify database data or structure. Runs INSERT, UPDATE, DELETE, CREATE TABLE, and other data modification commands safely through PostgreSQL driver with parameterized query support.
command必填stringSQL command to execute against the database (INSERT, UPDATE, DELETE, CREATE TABLE, etc.). Examples: 'INSERT INTO users (name, email) VALUES ($1, $2)', 'UPDATE users SET active = $1 WHERE id = $2', 'DELETE FROM sessions WHERE expires_at < NOW()', 'CREATE TABLE logs (id SERIAL PRI…
parametersarrayOptional array of parameters for parameterized commands using $1, $2, etc. placeholders. Example: command='INSERT INTO users (name, email) VALUES ($1, $2)', parameters=['John Doe', 'john@example.com']. Parameters are automatically escaped to prevent SQL injection.
connectionString必填stringPostgreSQL connection string for direct database access. Use the standard format: 'postgresql://USER:PASSWORD@HOST:PORT/DATABASE?sslmode=require'. Get credentials from create_connection or create_database response fields: use 'user' as USER, 'pass' as PASSWORD, and 'host' as HOS…
data必填Data from the action execution
errorstringError if any occurred during the execution of the action
successful必填booleanWhether or not the action execution was successful or not
OAuth 连接。风险等级 2/5。
免费操作
目前没有已发布技能明确引用此操作。