Skip to content
M↓ View as Markdown ↗

Prompts

The Actian MCP Server for Actian Zen includes a built-in prompt template. This feature acts as a bridge, transforming the plain language questions into the specific context needed for a database expert to provide accurate answers.

Available Prompts

Prompt Description
ask_question Formats a user’s question using a specialized Zen database expert template.

ask_question

The ask_question prompt takes a plain language question and wraps it in a template that identifies the AI assistant as a Zen (formerly Actian PSQL) database expert. This ensures the model approaches the query with the correct dialect and structural knowledge.

Parameters

Field Type Required Description
question string ✓ The question to insert into the prompt template.

Output Template

You are a Zen (Actian PSQL) database expert. Answer the following question: <question>

Example

Input

{
  "question": "What are the top 5 departments by employee count?"
}

Output

You are a Zen (Actian PSQL) database expert. Answer the following question: What are the top 5 departments by employee count?

Next Steps

  • Tools
    Learn more about the SQL and schema tools exposed by the Zen server.

  • Resources
    Explore the resource types available through the Zen server.