skills.rest
besoeasy
besoeasyCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/besoeasy/open-skills --skill database-query-and-export
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
bongrealtybongrealty
2

data-query

Translate natural language questions into SQL queries for BigQuery, PostgreSQL, MySQL, and SQLite.

Community
Intermediate
89jobrien89jobrien
4

file-converter

Generate Python code to convert files between document, data, and image formats.

Community
Advanced
iankikuiankiku
18

data

Design analytics systems, generate SQL queries, plan event tracking, and build dashboards.

Community
Advanced
TurnaboutHeroTurnaboutHero
12

data-wizard

Automate ETL and data transformation for CSV, JSON, and database sources using Python and pandas.

Community
Advanced