ai-agents-agent-creation-need-to-deploy-an-ai-agent-that-can-answer-questio-e6c0386f

THEN Use `CREATE AGENT` statement to define an agent with a model provider (e.g., OpenAI), linked knowledge bases, and tables. Provide a prompt template to guide the agent's behavior.

CREATE AGENT my_agent USING model = { 'provider': 'openai', 'model_name' : 'gpt-xx', 'api_key': 'sk-...' }, data = { 'knowledge_bases': ['mindsdb.customer_issues'], 'tables': ['salesforce.opportunities', 'postgres.sales', 'mongodb.support_tickets'] }, prompt_template = 'my prompt template and agent guidance';