Structured data access layer for AI agents

AI agents are good at reading docs and websites, but giving them direct access to your databases is risky. Pylar solves this by letting you create governed views of your data, publish them as MCP tools to any agent builder, and run evals to track safety and performance.

One governed access point for all your agents

Governed SQL Views

Define safe, scoped data views on your warehouse. Control exactly what data agents can access with fine-grained permissions.

Learn about data governance →
SQL Editor
1 CREATE VIEW customer_analytics AS
2 SELECT
3 c.customer_id,
4 c.email,
5 c.company_name,
6 t.ticket_count,
7 t.avg_resolution_time,
8 u.monthly_usage,
9 u.feature_adoption
10 FROM customers c
11 LEFT JOIN tickets t
12 ON c.customer_id = t.customer_id
13 LEFT JOIN usage_metrics u
14 ON c.customer_id = u.customer_id
15 WHERE c.status = 'active'
16 AND u.last_activity > '2024-01-01';
Results
customer_id
email
company_name
ticket_count
avg_resolution_time
monthly_usage
MCP TOOLS
fetch_customer
Edit
list_contacts
Edit
fetch_user_analytics
Edit
list_revenue_forecast
Edit
fetch_error_trends
Edit
list_churn_analysis
Edit
fetch_conversion_funnel
Edit
list_product_usage
Edit
AGENT VIEWS
support_errors
Published
user_analytics
Draft
error_trends
Published
revenue_forecast
Published
churn_analysis
Draft
conversion_funnel
Published
customer_segments
Draft
product_usage
Published
IN PROGRESS 3
*
fetch_error_codes
Generating
*
fetch_product_events
Generating
*
fetch_support_tickets
Generating
READY FOR REVIEW 3
fetch_customer_data
24m
Ready for agent integration...
get_analytics_summary
59m
+37 -0 Analytics tool ready...
list_user_activities
1h
+12 -3 User activity tool...
Create MCP Tools for Support Data
Generate MCP tools to help agents access support ticket data safely.
Create MCP tools for our support data. I need tools to fetch error codes, product events, and support tickets.
I'll create three MCP tools from your support views:
📄
fetch_error_codes +15-0
Error codes tool with error_type parameter
📄
fetch_product_events +12-0
Product events tool with date_range parameter
📄
fetch_support_tickets +18-0
Support tickets tool with status parameter
All set! Three MCP tools created and ready for agent integration.

Auto-Generated MCP Tools

Pylar automatically creates MCP tools from your SQL views, giving agents safe access to structured data without raw database queries.

Learn about MCP integration →

Publish Your Custom Tools

Create custom MCP tools on your specific views and publish them to your agent builders with a single link. Share tools across teams and environments.

Learn about custom tools →
Agent View Evals
support.support_customer_context
93.1%
Success Rate
1.4s
p95 Latency
95%
Hit Rate
$0.006
Cost/Call
16
Violations
Calls / Success / Errors
Latency p50 / p95
Error Explorer
Error Code
Count
auth_error
102
schema_error
74
timeout
59
Query Shape & Cost
Fingerprint
Calls
Cost
p95 (ms)
a48lb03c530
420
$75.0k
1450
ad575e90036
260
$47.0k
980
Raw Logs
ts
run_id
agent_id
tool_name
status
latency_ms
14:32:15
run_001
triage_bot
fetch_customer_context
success
2100
14:32:12
run_002
support_bot
fetch_customer_context
error
-
14:32:08
run_003
triage_bot
fetch_customer_context
success
1800

Evals & Observability Layer

Monitor agent performance, track query success rates, and measure data usage. Built-in governance and transparency for production AI systems.

Learn about evals →

Ship agent workflows on real data

Connect your stack in minutes

Works with BigQuery, Snowflake, Postgres, Redshift, and more. Model a view once, then publish MCP tools on top—no pipelines, no migration.

Supported Databases
BigQuery
Connected
Snowflake
Connected
PostgreSQL
Connected
Amazon Redshift
Connected
Databricks
Connected
ClickHouse
Connected
MySQL
Connected
Microsoft SQL Server
Connected

Governance built in

SOC 2–ready controls with fine-grained visibility. Limit what agents can query, parameterize inputs, and keep an audit trail for every call.

Access Controls
Row Filter
region = 'EU'
Columns
email, plan, mrr
Rate Limit
100/hour
Recent Activity
14:32 fetch_customer
14:28 list_contacts
14:25 get_errors

Ready-to-ship agent skills

From a single governed view, generate tools that drop straight into any agent builder. Scale use cases across the org, without ever exposing raw DB access.

Support Agent
Show me customer John's recent tickets
Using fetch_customer_tickets...
fetch_customer_tickets → 3 tickets found
Available Tools
fetch_customer Live
get_tickets Live
analytics Draft