fr-db

Detect database schemas and generate FineReport-ready SQL queries and XML fragments.

1|1|Updated Mar 20, 2026
One-click install
npx skills add https://github.com/s710082105/fine_d --skill fr-db
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: fr-db
Source: https://github.com/s710082105/fine_d/tree/main/.claude/skills/fr-db
Command: npx skills add https://github.com/s710082105/fine_d --skill fr-db

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Detect database schemas and generate FineReport-ready SQL queries to configure data sources, reducing manual data-mapping effort.

Core Features & Use Cases

  • Cross-database schema discovery for MySQL, PostgreSQL, Oracle, and SQL Server.
  • Generate SQL queries and corresponding TableData XML fragments tailored to FineReport.
  • Optional Python+SQLAlchemy-based inspection for environments where native clients are unavailable.

Quick Start

Provide database connection info (type, host, port, database, user, password) and run to obtain SQL and XML artifacts.

Frequently Asked Questions about fr-db

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

FAQPage Schema
How do I generate FineReport SQL queries from a database schema automatically?

To generate FineReport SQL queries, you provide database connection details and the tool detects schemas to output SQL queries and TableData XML fragments. This automates data source configuration by mapping schemas directly into FineReport-ready artifacts.

Can I use SQLAlchemy to inspect database schemas for FineReport when native clients are unavailable?

Yes, you can use a Python and SQLAlchemy-based inspection approach as an optional alternative. This allows schema discovery and artifact generation without requiring native database clients to be installed in your environment.

Does FineReport SQL generation support cross-database compatibility for MySQL, PostgreSQL, Oracle, and SQL Server?

Yes, FineReport SQL generation supports cross-database compatibility across MySQL, PostgreSQL, Oracle, and SQL Server. It guides users through connection and schema discovery to generate compatible SQL and XML artifacts for each database type.

What database connection information is needed to start generating SQL and XML artifacts?

You need to provide the database type, host, port, database name, username, and password to start generating SQL and XML artifacts. Supplying these connection parameters allows the tool to connect, inspect schemas, and output FineReport templates.

What is the best way to reduce manual data-mapping effort when configuring FineReport data sources?

The best way to reduce manual data-mapping effort is by automating schema discovery to output SQL and XML artifacts. This detects database structures and generates FineReport-ready queries, eliminating the need to manually map data fields.