Does it support SSL for cloud connections?

Yes, the Pydantic model includes mode-aware defaults that automatically enable SSL and set the correct ports (like 8443) for cloud instances.

How does this skill handle ClickHouse cloud credentials?

The skill follows a 'skill chain' approach where credentials can be retrieved via cloud management skills, stored in a gitignored .env file, and then injected into the DBeaver config.

Why use mise as the Single Source of Truth?

Using mise ensures that connection parameters like host, port, and database name are defined once in .mise.toml and shared across all development tools and scripts.

Will this overwrite my existing DBeaver configurations?

The skill includes an adaptation discovery phase to check for existing .dbeaver directories and can be configured to merge connections rather than simply overwriting them.

ClickHouse DBeaver Config Generator

Name: ClickHouse DBeaver Config Generator
Author: terrylica

byterrylica

•

Database Management

Generates DBeaver database client configurations from Pydantic models using mise as a single source of truth.

This skill automates the complex task of setting up DBeaver connections for ClickHouse by translating Pydantic v2 configuration models into the required JSON format. By utilizing mise environment variables as a Single Source of Truth (SSoT), it ensures that your database client settings remain consistent with your local development environment and cloud credentials. It handles both local and cloud connection modes, including SSL requirements and credential mapping, while maintaining security through gitignored configuration files.

Key Features

01Type-safe configuration validation using Pydantic v2 models

02Automated generation of DBeaver data-sources.json files

03Adaptable discovery workflow for existing repository patterns

042 GitHub stars

05Seamless integration with mise for environment variable management

06Mode-aware configuration for local and cloud ClickHouse instances

Use Cases

01Standardizing database client setup across a development team

02Automating connection configuration as part of a repository bootstrap process

03Quickly switching between local development and cloud ClickHouse environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add terrylica/cc-skills clickhouse-pydantic-config

For use in Claude.ai and ChatGPT

Download Skill