AIPrismaLayer Integration Setup Guide

The AIPrismaLayer integration provides full PrismaLayer (Superset) management from workspace prompts.

Overview

Agents can:

Read

• Dashboards: List all dashboards, get dashboard by ID or title
• Databases: List databases, get database, list tables, list schemas, test connection
• Charts: List charts, get chart, get chart data (with metric/country filters), list charts in a dashboard
• Datasets: List datasets, get dataset by ID or name
• Saved queries: List saved queries, get saved query by ID
• Tags: List all tags

Write

• Dashboards: Create, update, delete, copy dashboard
• Charts: Create, update, delete chart
• SQL: Execute query (SQL Lab or legacy), create/update/delete saved query
• Tags: Add tag to dashboard or chart

Setup

Step 1: Copy Files

Copy the integration files to the active plugins directory:

# Linux/Mac
mkdir -p backend/storage/plugins/agent-skills/aiprismalayer
cp -r path/to/aiprismalayer/* backend/storage/plugins/agent-skills/aiprismalayer/

# Windows (PowerShell)
New-Item -ItemType Directory -Force -Path "backend\storage\plugins\agent-skills\aiprismalayer"
Copy-Item -Path "path\to\aiprismalayer\*" -Destination "backend\storage\plugins\agent-skills\aiprismalayer\" -Recurse -Force

Step 2: Verify Plugin Configuration

Ensure plugin.json has "active": true:

{
  "active": true,
  "hubId": "aiprismalayer",
  ...
}

Step 3: Configure in AINexLayer

1. Navigate to Workspace Settings → Agent Skills
2. Find AIPrismaLayer in the list
3. Configure:
   • AIPRISMA_BASE_URL: Base URL of your AIPrismaLayer/Superset instance (e.g., http://localhost:8088)
   • AIPRISMA_USERNAME: Username for Superset authentication (default: admin)
   • AIPRISMA_PASSWORD: Password for Superset authentication (default: admin)
4. Save configuration

Step 4: Restart AINexLayer

Restart your AINexLayer server for changes to take effect.

Usage Examples

User: "Show me all available dashboards in AIPrismaLayer"
AI: [Calls get_dashboards and displays list]

User: "Show me all charts in the COVID Vaccine Dashboard"
AI: [Calls get_dashboard_charts and displays charts]

User: "What's in the Sales Dashboard?"
AI: [Calls get_dashboard and displays dashboard details]

User: "List all available databases in AIPrismaLayer"
AI: [Calls get_databases and displays list]

User: "Show me tables in the main database"
AI: [Calls get_database_tables and displays tables]

Available Operations

Dashboards

• get_dashboards - List all dashboards
• get_dashboard - Get specific dashboard by ID or title
• create_dashboard - Create a new dashboard
• update_dashboard - Update an existing dashboard
• delete_dashboard - Delete a dashboard
• copy_dashboard - Duplicate a dashboard

Charts

• get_charts - List all charts
• get_chart - Get specific chart by ID or title
• get_chart_data - Get actual data from a chart (with filters)
• get_dashboard_charts - List all charts in a dashboard
• create_chart - Create a new chart
• update_chart - Update an existing chart
• delete_chart - Delete a chart

Databases

• get_databases - List all databases
• get_database - Get specific database by ID or name
• get_database_tables - List tables in a database
• get_database_schemas - List schemas in a database
• test_database_connection - Test connection to a database

SQL Queries

• execute_query - Execute a SQL query on a database
• execute_sql - Execute SQL via SQL Lab
• list_saved_queries - List saved SQL Lab queries
• get_saved_query - Get specific saved query by ID
• create_saved_query - Create a saved query
• update_saved_query - Update a saved query
• delete_saved_query - Delete a saved query

Datasets

• get_datasets - List all datasets
• get_dataset - Get specific dataset by ID or name

Tags

• list_tags - List all tags
• add_tag - Add a tag to a dashboard or chart

Troubleshooting

Skill Not Appearing

• Verify files are copied to backend/storage/plugins/agent-skills/aiprismalayer/
• Check that plugin.json has "active": true
• Restart AINexLayer

Authentication Errors

• Verify AIPRISMA_BASE_URL is correct and accessible
• Check AIPRISMA_USERNAME and AIPRISMA_PASSWORD are correct
• Ensure Superset instance is running

Chart Data Not Loading

• Some chart data retrieval methods may require fixes
• Basic dashboard and chart listing should work
• Check Superset API logs for errors

400 Bad Request Errors

• May occur with complex chart data queries
• Try simpler queries first (dashboard listing, chart listing)
• Check Superset API documentation for endpoint requirements