Connecting to MistralAI

The MistralAI API uses API key authentication.

Using API Key Authentication

Your MistralAI API Key is required to create a connection to MistralAI. API Keys can be obtained from your MistralAI account at console.mistral.ai by navigating to the API Keys section. Once you have obtained the API key, set it in the ProfileSettings connection property.

Example Connection string

Profile=C:\profiles\MistralAI.apip;ProfileSettings='APIKey=my_api_key;';AuthScheme=APIKey;

Available Tables

The MistralAI profile provides access to the following tables:

• Agents: MistralAI agents with their configurations, instructions, and tools
• AudioTranscriptions: Audio file transcriptions using MistralAI speech recognition models
• BatchJobs: Batch processing jobs for asynchronous API requests
• ChatClassifications: Text classifications performed via the chat interface
• ChatCompletions: Chat completions using MistralAI language models
• ChatModerations: Content moderation results for chat messages
• Classifications: Text classification results using MistralAI models
• Conversations: Active conversations managed by MistralAI agents
• Embeddings: Vector embeddings generated from input text
• Files: Files uploaded to MistralAI for use with the API
• FimCompletions: Fill-in-the-middle code completions using Codestral
• Libraries: Document libraries for retrieval-augmented generation (RAG)
• LibraryAccesses: Access permissions for a specific library
• LibraryDocuments: Documents stored within a specific library
• Models: Available MistralAI language models
• Moderations: Content moderation results for input text
• OCR: Optical character recognition results for documents and images

Usage Examples

AudioTranscriptions:

SELECT * FROM AudioTranscriptions WHERE Model = 'voxtral-mini-latest' AND FileId = 'fd1147d2-fffd-4805-9d26-31dc541fb673'

BatchJobs:

SELECT * FROM BatchJobs

ChatClassifications:

SELECT * FROM ChatClassifications WHERE Model = 'mistral-medium-2505' AND Messages = '[{"content":"What is an apple?","role":"system"}]'

ChatCompletions:

SELECT * FROM ChatCompletions WHERE Model = 'mistral-medium-2505' AND Messages = '[{"content":"What is an apple?","role":"system"}]'

ChatModerations:

SELECT * FROM ChatModerations WHERE Model = 'mistral-moderation-latest' AND Messages = '[{"role": "user", "content": "I love programming."}]'

Classifications:

SELECT * FROM Classifications WHERE Model = 'mistral-moderation-latest' AND Input = '["I love programming.","I love swimming"]'

Conversations:

SELECT * FROM Conversations

Embeddings:

SELECT * FROM Embeddings WHERE Model = 'mistral-embed' AND Input = '"This is an apple."'

Files:

SELECT * FROM Files

FimCompletions:

SELECT * FROM FimCompletions WHERE Model = 'codestral-latest' AND Prompt = 'sum of first 3 prime numbers'

Libraries:

SELECT * FROM Libraries

LibraryAccesses:

SELECT * FROM LibraryAccesses WHERE LibraryId = '3fa85f64-5717-4562-b3fc-2c963f66afa6'

LibraryDocuments:

SELECT * FROM LibraryDocuments WHERE LibraryId = '3fa85f64-5717-4562-b3fc-2c963f66afa6'

Models:

SELECT * FROM Models

Moderations:

SELECT * FROM Moderations WHERE Model = 'mistral-moderation-latest' AND Input = '["This is a test message for moderation."]'

OCR:

SELECT * FROM OCR WHERE Model = 'mistral-ocr-latest' AND Document = '{"type": "file", "file_id": "ae2af3d7-ae4f-4886-bbd5-f27fc01cd592"}'

Connection Properties

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider.

---

Property	Description
APIKey	Your MistralAI API key used for authentication.
AuthScheme	The scheme used for authentication. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT