PPDS.Dataverse 1.0.0-beta.6

Power Platform Developer Suite

Pro-grade tooling for Power Platform developers. CLI, TUI, MCP server, VS Code extension, and NuGet libraries.

Quick Start

# Install the CLI tool
dotnet tool install -g PPDS.Cli

# Launch interactive TUI
ppds

# Or run commands directly
ppds auth create --name dev
ppds env select --environment "My Environment"
ppds data export --schema schema.xml --output data.zip

Platform Overview

NuGet Libraries

Package	NuGet	Description
PPDS.Plugins		Declarative plugin registration attributes
PPDS.Dataverse		High-performance connection pooling and bulk operations
PPDS.Migration		High-performance data migration engine
PPDS.Auth		Authentication profiles and credential management
PPDS.Query		SQL query engine with FetchXML transpilation and ADO.NET provider
PPDS.Cli		CLI tool with TUI (.NET tool)
PPDS.Mcp		MCP server for AI assistants (.NET tool)

Compatibility

Interactive TUI

Running ppds without arguments launches the interactive Terminal User Interface:

ppds  # Launches interactive TUI with guided workflows

The TUI provides a menu-driven interface for all PPDS operations, ideal for exploration and one-off tasks.

MCP Server

The MCP server enables AI assistants like Claude Code to interact with Dataverse:

# Install the MCP server
dotnet tool install -g PPDS.Mcp

# Add to Claude Code MCP settings
ppds-mcp-server

Capabilities:

• Query Dataverse using natural language
• Explore entity metadata
• Analyze plugin registrations
• Execute FetchXML and SQL queries

VS Code Extension

The VS Code extension provides IDE integration via JSON-RPC with the PPDS daemon:

• Environment and profile management
• Query execution with results view
• Plugin deployment workflows

Install from the VS Code Marketplace.

CLI Commands

PPDS.Plugins

Declarative attributes for configuring Dataverse plugin registrations directly in code.

dotnet add package PPDS.Plugins

[PluginStep(
    Message = "Create",
    EntityLogicalName = "account",
    Stage = PluginStage.PostOperation)]
[PluginImage(
    ImageType = PluginImageType.PreImage,
    Name = "PreImage",
    Attributes = "name,telephone1")]
public class AccountCreatePlugin : IPlugin
{
    public void Execute(IServiceProvider serviceProvider) { }
}

See PPDS.Plugins on NuGet for details.

PPDS.Dataverse

High-performance Dataverse connectivity with connection pooling, throttle-aware routing, and bulk operations.

dotnet add package PPDS.Dataverse

// Setup with typed configuration
services.AddDataverseConnectionPool(options =>
{
    options.Connections.Add(new DataverseConnection("Primary")
    {
        Url = "https://org.crm.dynamics.com",
        ClientId = "your-client-id",
        ClientSecret = Environment.GetEnvironmentVariable("DATAVERSE_SECRET")
    });
    options.Pool.DisableAffinityCookie = true; // 10x+ throughput improvement
});

// Usage
await using var client = await pool.GetClientAsync();
var account = await client.RetrieveAsync("account", id, new ColumnSet(true));

See PPDS.Dataverse documentation for details.

PPDS.Migration

High-performance data migration engine for Dataverse. Replaces CMT for automated pipeline scenarios with 3-8x performance improvement.

dotnet add package PPDS.Migration

// Setup
services.AddDataverseConnectionPool(options =>
{
    options.Connections.Add(new DataverseConnection("Target")
    {
        Url = "https://org.crm.dynamics.com",
        ClientId = "your-client-id",
        ClientSecret = Environment.GetEnvironmentVariable("DATAVERSE_SECRET")
    });
});
services.AddDataverseMigration();

// Export
var exporter = serviceProvider.GetRequiredService<IExporter>();
await exporter.ExportAsync("schema.xml", "data.zip");

// Import with dependency resolution
var importer = serviceProvider.GetRequiredService<IImporter>();
await importer.ImportAsync("data.zip");

Key Features:

• Parallel export (all entities exported concurrently)
• Tiered import with automatic dependency resolution
• Circular reference detection with deferred field processing
• CMT format compatibility (drop-in replacement)
• Security-first: no PII in logs, connection string redaction

See PPDS.Migration documentation for details.

PPDS.Query

SQL query engine for Dataverse with FetchXML transpilation and an ADO.NET provider.

dotnet add package PPDS.Query

// ADO.NET provider — standard .NET data access for Dataverse
using var connection = new PpdsDbConnection(pool);
await connection.OpenAsync();

using var command = connection.CreateCommand();
command.CommandText = "SELECT name, revenue FROM account WHERE revenue > @threshold";
command.Parameters.AddWithValue("@threshold", 1_000_000m);

using var reader = await command.ExecuteReaderAsync();
while (await reader.ReadAsync())
{
    Console.WriteLine($"{reader["name"]}: {reader["revenue"]:C}");
}

Key Features:

• Full T-SQL support (SELECT, JOIN, WHERE, GROUP BY, subqueries, CTEs, window functions)
• FetchXML transpilation with automatic pushdown optimization
• DML support (INSERT, UPDATE, DELETE) with safety guards
• Cross-environment queries with bracket syntax
• Streaming Volcano-model execution engine

See PPDS.Query documentation for details.

Development

Prerequisites

• .NET SDK 10.0+ (8.0 and 9.0 also supported)
• Node.js 20+ (for extension development)
• PowerShell 7+ (for scripts)

Opening the Project

Recommended: Open ppds.code-workspace in VS Code for full-stack development.

This provides:

• .NET solution navigation with C# Dev Kit
• Extension F5 debugging with correct path resolution
• Unified build/test tasks for both .NET and TypeScript
• Compound debugging for CLI + Extension integration testing

Alternatives:

• Open root folder for .NET-only development
• Open extension/ folder for extension-only development

Building

# Build .NET solution
dotnet build PPDS.sln

# Build extension
cd extension && npm run compile

# Or use VS Code tasks: Ctrl+Shift+B

Testing

# Unit tests (fast, no external dependencies)
dotnet test --filter Category!=Integration

# Integration tests (requires Dataverse connection)
dotnet test --filter Category=Integration

# TUI tests
dotnet test --filter Category=TuiUnit

Debugging (F5)

Patterns

• Connection Pooling - When and how to use connection pooling
• Bulk Operations - High-throughput data operations

Claude Code Integration

PPDS provides templates for Claude Code users developing Power Platform solutions:

• Consumer Guide - Best practices for PPDS development
• Recommended Settings - Permission configuration for PPDS commands
• Slash Commands - Quick reference commands

See templates/claude/INSTALL.md for installation instructions.

Related Projects

Contributing

See CONTRIBUTING.md for guidelines on contributing to PPDS.

License

MIT License - see LICENSE for details.