Aident logoAident logo centerAident Loadout
Use CasesPricingDocs
ENStart Now
AppsPrisma ToolsPrisma Execute Sql Query
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…

Write actionRisk level 2 of 5OAuth connection
Use Prisma Execute Sql Query

Pricing and limits

Aident logo

Product

Aident LoadoutAident Playbook EditorOpen-CUAK

About

AppsSkillsUse CasesDocsBlogPricingDownloadsPrivacy PolicyTerms of Service

Alternatives

vs Composiovs Zapier
llms.txtGet an AI summary of Aident LoadoutSummarize with ChatGPTSummarize with ClaudeSummarize with GeminiSummarize with Perplexity

© Aident Labs, 2024-2026

Pricing
Free
Unified payment
Not currently supported

Inputs

  • hoststring
    Required
    Database 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.
  • userstring
    Required
    Database username (tenant ID from Prisma). Obtain this from create_connection action response field 'user'. This is a unique identifier for your database tenant.
  • querystring
    Required
    SQL 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…
  • passwordstring
    Required
    Database password (secret key from Prisma). Obtain this from create_connection action response field 'pass'. Format is typically 'sk_xxxxx'. Keep this secure.
  • parametersarray
    Optional 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…

Observable output

  • data
    Required
    Data from the action execution
  • errorstring
    Error if any occurred during the execution of the action
  • successfulboolean
    Required
    Whether or not the action execution was successful or not

Skills that use this Action

Related use cases

No verified related use cases are linked yet.

Official source

Provider source

Skills that use this Action

No published Skills explicitly reference this Action yet.