skills.rest
wilsonfreitas
wilsonfreitasCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

brasa-db-explorer

Query BrasaDB's DuckDB backend to explore tables, schemas, and datasets.

51|8|Updated Feb 18, 2023
Search Tags:#sql#query#exploration#duckdb#datasets#brasadb
One-click install
npx skills add https://github.com/wilsonfreitas/brasa --skill brasa-db-explorer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: brasa-db-explorer
Source: https://github.com/wilsonfreitas/brasa/tree/main/.claude/skills/brasa-db-explorer
Command: npx skills add https://github.com/wilsonfreitas/brasa --skill brasa-db-explorer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Connect to BrasaDB's DuckDB database and run SQL queries to explore Brazilian financial market data, enabling fast ad-hoc analysis and discovery of datasets.

Core Features & Use Cases

  • Discover available tables and schemas
  • Execute SQL queries across input, staging, and curated layers
  • Create derived views to support analysis and reporting

Quick Start

Start by connecting to the BrasaDB DuckDB file at BRASA_DATA_PATH/db/brasa.duckdb and running a sample SQL query to explore the data.

Frequently Asked Questions about brasa-db-explorer

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

FAQPage Schema
How do I query Brazilian financial market data with SQL using DuckDB?▼

To run SQL queries on BrasaDB, connect to the DuckDB file at BRASA_DATA_PATH/db/brasa.duckdb. You can then execute SQL to join and transform datasets across input, staging, and curated layers for ad-hoc analysis.

What is the best way to explore DuckDB schemas and table structures for datasets?▼

The best way to explore schemas is by connecting to the BrasaDB DuckDB backend, which allows discovering available tables and inspecting schemas across input, staging, and curated layers for insights.

Can I create and save derived views when analyzing DuckDB datasets?▼

Yes, you can create derived views. The Skill connects to the BrasaDB DuckDB file using read_only=False, enabling view creation during analysis to support reporting and data transformation across staging and curated layers.

Does BrasaDB Explorer support joining tables across different data layers?▼

Yes, BrasaDB Explorer supports joining tables across different data layers. You can execute SQL to join and transform datasets across input, staging, and curated layers within the DuckDB backend for comprehensive insights.

What are the limitations of using read_only=False mode for DuckDB data exploration?▼

Using read_only=False for DuckDB data exploration enables view creation but allows database modifications. While supporting derived views for analysis, this mode permits changes to the BrasaDB file rather than restricting access to read-only inspection.

Related Skills

Explore More Data & Analytics Skills→
alexradunetalexradunet
10

dufs

Serve the home directory over WebDAV on a NetBird mesh network.

Community
Basic
nq-rdlnq-rdl

convert-file

Convert data files between formats using DuckDB COPY statements.

Official
Intermediate
elophantoelophanto
116

analytics-reporting

Analyzes raw data to build dashboards, reports and KPI tracking using SQL and Python/R.

Community
Advanced
xiaoyuge886xiaoyuge886
196

whodb

Explore schemas, inspect tables, and execute SQL queries across multiple database engines.

Community
Intermediate