> ## Documentation Index
> Fetch the complete documentation index at: https://help.peliqan.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Peliqan documentation

> Peliqan is the Trust data layer for BI and AI. Get started with one-click ETL pipelines, magical SQL, low-code Python, and 300+ data connectors.

Peliqan is the **Trust layer** for BI and AI. Peliqan provides one-click ETL pipelines from 300+ sources. Peliqan has a built-in data warehouse or you can use your own (Snowflake, BigQuery, Redshift, SQL Server, Fabric etc). Peliqan combines magical SQL with low-code Python to get work done fast, including setting up BI, data activation, vibe coding & publishing Data Apps and APIs, embedding, MCP access and building AI Agents.

<Card title="Peliqan MCP" icon="robot" href="/low-code-python-data-apps/by-protocol-rest-webhooks-mqtt/mcp-model-context-protocol/peliqan-mcp-server">
  Add Peliqan in ChatGPT, Claude, Gemini, Copilot or any other MCP client. Get instant access to your business data, and interact with your business apps. More info:
</Card>

## Basics

<CardGroup cols={2}>
  <Card title="Overview and concepts" icon="book-open" href="/overview-and-concepts" />

  <Card title="ELT: Connect to data" icon="plug" href="/connect-to-data" />

  <Card title="Working with data in the Data Explorer" icon="table" href="/working-with-data-in-the-grid-view" />

  <Card title="Data warehouse" icon="database" href="/data-warehouse-materialize-tables" />

  <Card title="Connect your BI, DB tool or iPaaS" icon="link" href="/connect-your-bi-or-db-tool" />

  <Card title="Excel add-in" icon="file-excel" href="/excel-add-in" />

  <Card title="Permissions" icon="lock" href="/permissions" />

  <Card title="Market place: install Metabase etc." icon="store" href="/market-place" />

  <Card title="Frequently asked questions" icon="circle-question" href="/frequently-asked-questions" />

  <Card title="Feature list and Architecture" icon="list" href="/feature-list-roadmap-and-architecture" />

  <Card title="Platform status" icon="heart-pulse" href="/platform-status" />
</CardGroup>

## Advanced

<CardGroup cols={2}>
  <Card title="SQL on anything" icon="code" href="/sql-on-anything" />

  <Card title="Joining data" icon="object-group" href="/joining-data" />

  <Card title="Data transformations" icon="wand-magic-sparkles" href="/data-transformations" />

  <Card title="Metadata, Data models & Semantic models" icon="sitemap" href="/metadata-data-model-semantic-model" />

  <Card title="Materialize & Replicate" icon="copy" href="/materialize" />

  <Card title="Data Lineage" icon="diagram-project" href="/data-lineage" />

  <Card title="Reverse ETL" icon="rotate" href="/reverse-etl" />

  <Card title="Data Mapper" icon="map" href="/data-mapper" />

  <Card title="IP whitelisting" icon="shield-halved" href="/ip-whitelisting" />

  <Card title="On-prem connectivity" icon="network-wired" href="/on-prem-connectivity" />
</CardGroup>

## For Partners

<CardGroup cols={2}>
  <Card title="Multi-customer management" icon="users" href="/multi-customer-management" />

  <Card title="Manage sub accounts" icon="sitemap" href="/manage-sub-accounts" />

  <Card title="Service models" icon="briefcase" href="/whitelabel" />

  <Card title="Whitelabel" icon="paintbrush" href="/whitelabel/whitelabel" />

  <Card title="Partner API" icon="plug" href="/whitelabel/partner-api-embed-api" />

  <Card title="Embedding" icon="window-restore" href="/whitelabel/embedding" />

  <Card title="Pipeline webhooks" icon="webhook" href="/pipeline-webhooks" />

  <Card title="pq Functions for partners" icon="function" href="/pq-functions-for-partners" />
</CardGroup>

## For AI creators 🤖

<CardGroup cols={2}>
  <Card title="Build a custom AI client (harness) in Peliqan" icon="robot" href="/build-ai-agents-in-peliqan" />

  <Card title="Build AI agents with n8n and Peliqan" icon="robot" href="/build-ai-agents-with-n8n-and-peliqan" />

  <Card title="Build a custom MCP Server on Peliqan" icon="server" href="/low-code-python-data-apps/by-protocol-rest-webhooks-mqtt/mcp-model-context-protocol/build-a-remote-mcp-server-on-peliqan" />

  <Card title="Implement RAG" icon="magnifying-glass" href="/build-ai-agents-in-peliqan/rag" />
</CardGroup>

## Popular Data App templates

### Handling data

* [Generate Union Query](/generate-union-query)
* [Slow changing dimensions (history tables)](/low-code-python-data-apps/slow-changing-dimensions-history-tables)
* [Handling deleted rows](/low-code-python-data-apps/etl-custom-pipelines/handling-deleted-rows)
* [Predictions, Machine Learning templates](/low-code-python-data-apps/predictions-machine-learning-templates)

### Interaction & reporting

* [Send alert to MS Teams](/send-alert-to-msteams)
* [Send alerts to Slack](/low-code-python-data-apps/predictions-machine-learning-templates/send-alerts-to-slack)
* [Data Visualization (Streamlit)](/low-code-python-data-apps/data-visualization)
* [Interactive apps (Streamlit)](/low-code-python-data-apps/interactive-apps)
* [Reporting](/low-code-python-data-apps/reporting)

### Pipelines

* [Data enrichment](/low-code-python-data-apps/data-enrichment)
* [Writeback to SaaS APIs](/low-code-python-data-apps/writeback-reverse-etl-data-sync)
* [Custom data syncs](/low-code-python-data-apps/writeback-reverse-etl-data-sync/data-sync-and-data-imports)
* [Data quality, monitoring & contracts](/low-code-python-data-apps/data-quality-monitoring)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.