open-index/open-npm huggingface dataset:
npm package: @rudrprasad05/image-upload
Description: A simple utility to upload files to S3
Author: Your Name
Latest version: 1.0.0

# upload-file-to-s3

A simple utility to upload files to S3 using axios.

## Installation

```sh
npm install upload-file-to-s3
```

```javascript
import { uploadFileToS3 } from "upload-file-to-s3";

const file = new FormData();
file.append("file", selectedFile); // Assuming `selectedFile` is a File object

await uploadFileToS3(file)
  .then((response) => {
    console.log("File uploaded successfully:", response);
  })
  .catch((error) => {
    console.error("Error uploading file:", error);
  });
```
npm package: @rudsys/n8n-nodes-mikrotik-api
Description: n8n node for interacting with Mikrotik API
Author: RudSys
Latest version: 0.1.13

# n8n-nodes-mikrotik

This is an n8n node for interacting with the Mikrotik API.

## Features

- Execute custom commands on Mikrotik RouterOS devices via the API service (port 8728/8729).
- Supports secure authentication using n8n credentials.
- Supports TLS connection.

## Installation

Follow the [n8n guide](https://docs.n8n.io/integrations/creating-nodes/build/node-development-environment/) to install this node into your n8n instance.

## Usage

1. Create a **MikroTik API** credential with your RouterOS Host, Port (default 8728), Username, and Password.
2. Add the **MikroTik API** node to your workflow.
3. Enter the command you want to execute (e.g., `/ip/address/print`).

## Development

```bash
npm install
npm run dev
```

## License

MIT
npm package: @rudsys/n8n-nodes-sqlite3
Description: n8n node for Remote SQLite operations via SSH
Latest version: 0.1.18

# n8n-nodes-sqlite3

This is an n8n community node to perform CRUD operations on a **Remote SQLite Database** via **SSH**.

It allows you to manage SQLite databases hosted on remote servers (e.g., VPS, Shared Hosting) without downloading the file.

## Prerequisites

1.  **SSH Access** to the remote server.
2.  **`sqlite3`** binary must be installed and available in the PATH on the remote server.
    - Test it by running `ssh user@host "sqlite3 --version"`
    - If it's not in PATH, you might need to symlink it or use the full path (currently not configurable, defaults to `sqlite3`).

## Operations

### 1. Execute Query

Run any raw SQL query. Useful for complex `JOIN`s, `GROUP BY`, or subqueries.

- **Query:** Type your SQL (e.g., `SELECT * FROM users JOIN orders ON users.id = orders.user_id`).

### 2. Insert

Insert data from n8n items into a table.

- **Conflict Mode:**
  - **Abort:** Fail if a constraint is violated (default).
  - **Ignore:** Skip row on conflict (`INSERT OR IGNORE`).
  - **Replace:** Overwrite existing row (`INSERT OR REPLACE`).

### 3. Select

Read data from a table with advanced options.

- **Columns:** Specify columns (e.g., `id, name, email`) or use `*`. Support for aggregates (e.g., `COUNT(*)`).
- **Distinct:** Toggle `SELECT DISTINCT` to remove duplicates.
- **Filters:** Add multiple conditions (AND logic):
  - Operators: `=`, `!=`, `<`, `<=`, `>`, `>=`, `LIKE`, `NOT LIKE`, `GLOB`, `IN`, `NOT IN`, `BETWEEN`, `IS NULL`, `IS NOT NULL`.
- **Sort:** Order results by one or more columns (ASC/DESC).
- **Limit & Offset:** Control pagination.

### 4. Update

Update rows in a table based on conditions.

- **Filters:** Specify which rows to update (WHERE clause).
- **Data:** The fields in your input JSON will be set in the database.

### 5. Delete

Delete data or tables.

- **Mode:**
  - **Delete Rows:** Remove specific rows based on Filters.
  - **Drop Table:** Remove the entire table and its structure.

### 6. Vacuum

- Run `VACUUM` command to rebuild the database file and reclaim space.

## Credentials

Requires **SQLite SSH Credentials**:

- Host
- Port
- Username
- Password OR Private Key

## Output Format

The node attempts to use `sqlite3 -json` for parsing results.

- **JSON (Preferred):** Requires SQLite 3.33.0+ on the remote server.
- **CSV (Fallback):** Can be selected in "Options" if your remote SQLite version is older. Note: CSV parsing is basic.

## License

MIT