skills.rest
shekerkamma
shekerkammaCOMMUNITY
Explore all skills by this author →
GitHub

connect-data

Connect CSV, DuckDB, MotherDuck, PostgreSQL, BigQuery, and Snowflake data sources.

Updated May 22, 2026
Search Tags:#database-setup#credential-security#dataset-management#csv-ingestion#schema-profiling#data-connection#sql-databases
One-click install
npx skills add https://github.com/shekerkamma/peopletech-marketplace --skill connect-data-shekerkamma
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: connect-data
Source: https://github.com/shekerkamma/peopletech-marketplace/tree/main/plugins/ai-analyst/skills/ai-analyst/connect-data
Command: npx skills add https://github.com/shekerkamma/peopletech-marketplace --skill connect-data-shekerkamma

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Manually configuring connections to disparate data sources like databases and CSV files is time-consuming, error-prone, and requires specialized knowledge of each platform's unique credential and setup requirements, blocking analysts from quickly accessing data for analysis.

Core Features & Use Cases

  • Multi-source connection wizard: Supports CSV files, DuckDB, MotherDuck, PostgreSQL, BigQuery, and Snowflake with step-by-step guided setup tailored to each connection type.
  • Automated schema profiling: Automatically enumerates tables, captures column types, and generates a structured schema document to eliminate manual data mapping work.
  • Centralized dataset management: View all connected datasets, switch between active sources, and track usage stats via the built-in /datasets command.
  • Use Case: A product analyst can connect their team's PostgreSQL database in minutes, automatically get a full schema overview, and start exploring data without writing manual connection code.

Quick Start

Use the connect-data skill to set up a connection to your PostgreSQL database and generate its full schema profile for analysis.

Frequently Asked Questions about connect-data

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I connect a PostgreSQL database for analytics without writing manual connection code?▼

Connecting a PostgreSQL database for analytics requires a guided wizard that provides step-by-step setup tailored to the platform, validates the connection before activation, and automatically generates the required dataset metadata for downstream analysis.

Can I ingest CSV files and automatically profile their schema?▼

Yes, you can ingest CSV files and automatically profile their schema. The system automatically enumerates tables, captures column types, and generates a structured schema document to completely eliminate manual data mapping work.

Does this data connection wizard support BigQuery and Snowflake?▼

Yes, the data connection wizard supports BigQuery and Snowflake. It provides step-by-step guided setup tailored to each specific connection type while enforcing credential security best practices throughout the configuration process.

What is the best way to manage multiple disparate data source connections centrally?▼

The best way to manage multiple disparate data source connections centrally is using a built-in command to view all connected datasets, switch between active sources, and track usage stats across your analytics workflows.

How does credential security work when setting up database connections?▼

Credential security for database connections works by enforcing best practices during the configuration process and validating all connections before activation, ensuring sensitive information is protected when connecting to sources like PostgreSQL or Snowflake.

Do I need specialized knowledge to configure a DuckDB or MotherDuck connection?▼

No, you do not need specialized knowledge to configure a DuckDB or MotherDuck connection. The guided wizard handles the platform-specific setup requirements and eliminates the manual, error-prone configuration processes normally required.

Related Skills

Explore More Data & Analytics Skills→
Amar1404Amar1404
1

connect-data

Connect to CSV, DuckDB, PostgreSQL, BigQuery, Snowflake, Athena, and ClickHouse data sources.

Community
Intermediate
ai-analyst-labai-analyst-lab
21

deep-profile

Profile active datasets to generate schema and profiling insights.

Official
Advanced
monch1962monch1962
3

clickhouse-io

Design ClickHouse schemas and optimize analytical queries for large datasets.

Community
Basic
logicalclockslogicalclocks
15

hops-data-sources

Automate external data source ingestion and mounting into Hopsworks.

Official
Intermediate