通过 Aident Loadout 使用 Prisma Tools 的 Prisma Execute Sql Query。执行前查看输入、输出、设置、价格和风险。
Execute SQL SELECT queries against Prisma Postgres databases. Runs read-only queries safely through direct PostgreSQL connection with SSL. Uses credentials from create_connection action (host, user, pass fields). Perfect for data analysis, schema inspection, and reporting operat…
host必填stringDatabase host with port (format: 'db.prisma.io:5432'). Obtain this from create_connection action response field 'host'. This is the direct PostgreSQL endpoint for your Prisma Postgres database.
user必填stringDatabase username (tenant ID from Prisma). Obtain this from create_connection action response field 'user'. This is a unique identifier for your database tenant.
query必填stringSQL SELECT query to execute against the database. Use standard PostgreSQL syntax. Common examples: 'SELECT * FROM users LIMIT 10', 'SELECT name, email FROM customers WHERE active = true', 'SELECT table_name FROM information_schema.tables WHERE table_schema = \'public\''. Avoid I…
password必填stringDatabase password (secret key from Prisma). Obtain this from create_connection action response field 'pass'. Format is typically 'sk_xxxxx'. Keep this secure.
parametersarrayOptional array of parameters for parameterized queries using %s placeholders. Example: query='SELECT * FROM users WHERE id = %s AND active = %s', parameters=[123, true]. Parameters are automatically escaped to prevent SQL injection. Use %s for each parameter in order they appear…
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。
免费操作
目前没有已发布技能明确引用此操作。