database-query-and-export
Database Query and Export
Query relational databases (SQLite, PostgreSQL, MySQL) and export results to CSV, JSON, or other formats. Essential for data extraction, reporting, backup automation, and analytics pipelines.
When to use
- Use case 1: When the user asks to query a database and export results
- Use case 2: When you need to extract data for analysis or reporting
- Use case 3: For backup and data migration workflows
- Use case 4: When building automated database monitoring and alerts
Required tools / APIs
- SQLite — Lightweight file-based database (often pre-installed)
- PostgreSQL client — For PostgreSQL databases
- MySQL client — For MySQL/MariaDB databases
- No external API required
Install options:
More from besoeasy/open-skills
news-aggregation
Aggregate and deduplicate recent news from multiple sources into concise topic summaries.
151free-geocoding-and-maps
Geocode addresses and get map data using free OpenStreetMap Nominatim API. Use when: (1) Converting addresses to coordinates, (2) Reverse geocoding coordinates to addresses, (3) Location-based features, or (4) Validating addresses.
68get-crypto-price
Fetch current and historical crypto prices and compute ATH or ATL over common time windows.
49anonymous-file-upload
Upload and host files anonymously using decentralized storage with Originless and IPFS.
48trading-indicators-from-price-data
Compute common trading indicators from OHLCV price data for analysis and strategy development.
46json-and-csv-data-transformation
Transform data between JSON, CSV, and other formats with filtering, mapping, and flattening. Use when: (1) Converting API responses to CSV, (2) Processing data pipelines, (3) Extracting specific fields, or (4) Flattening nested structures.
45