h2-database

Connect to an H2 database via JDBC URL and run SQL queries.

Updated Mar 4, 2026
One-click install
npx skills add https://github.com/rodrigopalhares/big-cat-stock-tamer --skill h2-database
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: h2-database
Source: https://github.com/rodrigopalhares/big-cat-stock-tamer/tree/main/.claude/skills/h2-database
Command: npx skills add https://github.com/rodrigopalhares/big-cat-stock-tamer --skill h2-database

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps developers and testers connect to the application's H2 file-based database, run ad-hoc SQL queries, inspect table schemas, and verify data integrity for debugging and development tasks.

Core Features & Use Cases

  • Connect to the H2 database via the H2 Shell using the JDBC URL and driver details.
  • Execute SQL queries to inspect assets, transactions, dividends, price history, and other schema components.
  • Review the database schema and perform lightweight data verifications to troubleshoot issues or validate changes.

Quick Start

In a terminal, run the H2 Shell using the provided JDBC URL to connect to jdbc:h2:file:C:/ws/stocks/data/stocks;AUTO_SERVER=TRUE and start querying.

Frequently Asked Questions about h2-database

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

FAQPage Schema
How do I connect to an H2 file-based database using a JDBC URL?

You can connect to an H2 file-based database by running the H2 Shell in a terminal with the JDBC URL jdbc:h2:file:C:/ws/stocks/data/stocks;AUTO_SERVER=TRUE and the appropriate driver details to establish a session.

How do I inspect and verify table schemas in an H2 database?

You can inspect H2 database schemas by executing SQL queries through the H2 Shell to review table structures for assets, transactions, dividends, and price history, enabling lightweight data verifications to troubleshoot issues.

Can I run ad-hoc SQL queries to validate data integrity in an H2 database?

Yes, you can execute ad-hoc SQL queries via the H2 Shell to verify data integrity, investigate anomalies, and validate database migrations across assets, transactions, dividends, and history tables for debugging tasks.

What do I need to access the H2 Shell and query my application's data?

You need terminal access and the correct JDBC URL with AUTO_SERVER enabled to use the H2 Shell and query your application's H2 database, allowing reliable data inspection and cleanup tasks without extra dependencies.

When should I use the H2 Shell for database troubleshooting instead of other methods?

Use the H2 Shell for database troubleshooting when you need to quickly investigate data integrity, test SQL queries, or examine table structures across assets and transactions in a file-based H2 database environment.