This page describes how row-level-access can be implemented in Peliqan, for example in a Data App, in an AI Chatbot, in an MCP Server or in any other client that uses SQL queries to retrieve data (a.k.a. conversational analytics).

Example clients using row-level data access:

• Data apps
• MCP Servers with Text-To-SQL
• AI Chatbots

User authentication

In order to apply row-level permissions, each individual user in the client must be authenticated and known to Peliqan. This means that e.g. a shared API key cannot be used. Instead SSO (Single Sign On) with e.g. oAuth is appropriate.

User authentication in Data Apps

More info:

Publish & Embed apps

User authentication in MCP Servers using oAuth

More info:

Build a custom MCP Server on Peliqan with OAuth

User authentication in AI Chatbots

In order to apply permissions, the user id must be captured from the chat. Here’s an example setup in n8n using the n8n Chat Embed Widget:

• Parent webpage with login screen
• After login, send user_id into n8n Chat Embed Widget
• Retrieve user_id in n8n workflow