skills.rest
sky770825
sky770825COMMUNITY
Explore all skills by this author →
GitHub

Universal Data Connector

Query SQLite, PostgreSQL, and MySQL databases via a command-line interface.

Updated Feb 3, 2026
Search Tags:#database#data access#sqlite#sql#connector#postgres
One-click install
npx skills add https://github.com/sky770825/openclaw-console-hub --skill universal-data-connector
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Universal Data Connector
Source: https://github.com/sky770825/openclaw-console-hub/tree/main/armory/universal-data-connector
Command: npx skills add https://github.com/sky770825/openclaw-console-hub --skill universal-data-connector

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires sqlite3, json, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides a unified interface to interact with various database systems, abstracting away the complexities of different connection methods and query languages.

Core Features & Use Cases

  • Modular Design: Easily add support for new databases by creating new modules.
  • Cross-Database Interaction: Query SQLite, PostgreSQL, MySQL, and more through a single command structure.
  • Use Case: As a data analyst, you need to join data from a local SQLite database and a remote PostgreSQL instance. Use the Universal Data Connector to query both and combine the results.

Quick Start

Use the db skill to list all tables in the local sqlite database file named 'my_app.db'.

Frequently Asked Questions about Universal Data Connector

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

FAQPage Schema
How do I query multiple databases like SQLite and PostgreSQL using a single command-line interface?▼

You can query multiple databases through a unified command structure that abstracts connection complexities. This modular interface supports executing queries, listing tables, and retrieving schema definitions across diverse systems like SQLite and PostgreSQL.

What is the best way to list tables and retrieve schema definitions across different SQL databases?▼

Retrieving schema definitions and listing tables across SQL databases is handled by modular Python scripts. These scripts execute module-specific logic to interface with your target database and return structural metadata.

Can I use Python scripts to add support for a new database connector?▼

Yes, you can add support for new database connectors using Python scripts. The modular design allows you to create new modules that integrate into the existing command-line interface for cross-database interaction.

Does this database connector require specific dependencies to interact with local SQLite files?▼

Interacting with local SQLite files requires the sqlite3 and json dependencies. Once installed, you can execute commands to query data and manage your local SQLite database through the command-line interface.

How do I combine query results from a local SQLite database and a remote PostgreSQL instance?▼

To combine query results from SQLite and PostgreSQL, you query both databases through the unified interface. This allows you to interact with diverse systems and aggregate the returned data for analysis.

What databases are supported by default for cross-database interaction?▼

Cross-database interaction supports SQLite, PostgreSQL, and MySQL by default. The modular architecture enables querying these diverse systems through a single, consistent command structure.

Related Skills

Explore More Software Engineering Skills→
diegoliriodiegolirio

setup-db-mcp

Configure MCP servers for database connectivity from a connection string.

Community
Advanced
BirdywenBirdywen
1

sqlite-data

Create, query, analyze, and export SQLite data via the sqlite3 CLI.

Community
Intermediate
hschnehschne
1

jq

Query, filter, validate, and transform JSON data using jq.

Community
Intermediate
Axel-DaMageAxel-DaMage
2

sql-pro

Optimize SQL queries and design database schemas with indexing strategies.

Community
Advanced