connection

What problem does it solve?

BeepDM users often struggle to configure, validate, and secure datasource connections across diverse data sources. This Skill provides expert guidance on defining ConnectionProperties, linking appropriate drivers, processing and validating connection strings, and enforcing security best practices during setup.

Core Features & Use Cases

• Guidance on crafting and validating ConnectionProperties for common data sources (SQL Server, MySQL, PostgreSQL, SQLite).
• Driver linking and dynamic driver resolution to avoid hard-coded package names, ensuring compatibility with BeepDM's config editor.
• Secure handling of connection strings, including masking, placeholder replacement, and path normalization for file-based connections.
• Use Case: Onboarding a new data source, follow this Skill to configure properties, resolve the correct driver, validate the connection string, and instantiate the datasource with minimal manual trial-and-error.

Quick Start

Define your connection properties for your data source, fetch the best matching driver with GetBestMatchingDriver from the editor's config, apply the driver details, validate the connection string, and create and open the data source.