database-query-and-export

Query SQLite, PostgreSQL, and MySQL databases and export results to CSV or JSON.

128|31|Updated Feb 13, 2026

Search Tags:#database #postgresql #json #sqlite #sql #query #csv #mysql #export

Ready to run

npx skills add https://github.com/besoeasy/open-skills --skill database-query-and-export

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-query-and-export
Source: https://github.com/besoeasy/open-skills/tree/main/skills/database-query-and-export
Command: npx skills add https://github.com/besoeasy/open-skills --skill database-query-and-export

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the process of querying various relational databases (SQLite, PostgreSQL, MySQL) and exporting the results into common formats like CSV and JSON, eliminating manual data extraction and reporting efforts.

Core Features & Use Cases

Database Querying: Execute SQL queries against SQLite, PostgreSQL, and MySQL databases.
Data Export: Export query results to CSV or JSON formats.
Use Case: Automatically extract all customer orders from the last month from a PostgreSQL database and save them as a CSV file for a sales report.

Quick Start

Use the database-query-and-export skill to query the 'users' table in 'database.db' and export the results to 'users.csv'.

Frequently Asked Questions about database-query-and-export

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

FAQPage Schema

How do I export SQL query results to CSV or JSON?▼

To export SQL query results to CSV or JSON, you can execute SQL queries against SQLite, PostgreSQL, or MySQL databases and automatically save the extracted data into your chosen format for reporting and analysis.

Can I query a PostgreSQL database and save the output as a CSV file?▼

Yes, you can query a PostgreSQL database using the psql client tool and directly export the resulting data output into a CSV file, automating manual data extraction tasks for sales reports or backups.

Do I need database client tools to extract data from MySQL and SQLite?▼

Yes, extracting data from MySQL and SQLite requires specific database client tools like mysql and sqlite3, and optionally Node.js drivers for programmatic execution of SQL queries and data exports.

What is the best way to automate database backups and data extraction?▼

The best way to automate database backups and data extraction is by running SQL queries across SQLite, PostgreSQL, or MySQL databases and exporting the results directly to structured JSON or CSV files.

Does this database export approach work with SQLite, MySQL, and PostgreSQL?▼

Yes, this database export approach works with SQLite, MySQL, and PostgreSQL by leveraging their respective client tools to execute SQL queries and export the retrieved data into common formats.

Are there limitations when using Node.js drivers for database querying?▼

Limitations when using Node.js drivers for database querying include the optional requirement of having Node.js installed, while standard SQL querying and CSV or JSON exporting relies entirely on native database client tools.