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。
無料 Action
この Action を明示的に参照する公開 Skills はまだありません。