Datamates

Last updated Version Installs

Introduction

Datamates extension gives you the power to use AI TeamMates and automate your data work ranging from building, debugging and testing data pipelines to managing your data infrastructure.

We call these teammates "Datamates", and they integrate with your entire tool stack.

Datamates -

Provides direct access to your data tools through natural language commands
Maintains organizational memory and best practices across your team
Protects sensitive data with built-in PII detection and guardrails
Enables seamless collaboration through shared knowledge and contexts

If you need help with setting up the extension, please check the documentation.

Key Features

🔧 Tool Integration

Connect and control your entire data stack through natural language:

Data Stores: Snowflake, BigQuery, Databricks, PostgreSQL
Orchestration: Airflow
Version Control: GitHub
Project Management: Jira
Data Transformation: dbt
Generic Database Support: Most DBs are supported via SQL Tools
Custom Python, API and MCPs Integrations are supported

📚 Knowledge Hub

Centralize your team's expertise and documentation:

Upload organizational best practices and guidelines
Access documentation directly in your AI assistant
Create referenceable links for DOCS in Cursor, #fetch in GitHub Copilot, or @web in Windsurf
Maintain consistency across all team members

🧠 Memory Hub

Never lose context or repeat work:

Automatically searches relevant past interactions based on current tasks
Builds on previous solutions and learnings
Shares institutional knowledge across projects
Provides personalized assistance based on work history

🛡️ Enterprise Security

Protect your sensitive data:

PII detection and guardrails prevents accidental data exposure
Control what information reaches LLM providers
Complete audit trail and usage analytics
Compliance-ready security features

Examples

Automate Building and Testing Data Pipelines

Datamates will help get issue details from Jira, understand your dbt project structure and code, understand your best practices and previous changes to identify the root cause, make the fixes, compile the model, check dependencies, examine column mappings, and merge your final changes to production.

Automate Migrations

Transform PySpark code to dbt models with Datamates' conversion assistance. You can analyze PySpark repositories, and create equivalent dbt models and marts.

Datamates helps you understand schema structures, lineage and build models with proper dependencies. You can validate outputs by executing SQL on both implementations. Compile and test each converted model to ensure accuracy while maintaining comprehensive transformation documentation.

pysdbt