Begin by exporting your Trello board data. Trello allows you to export boards in JSON format. Navigate to the Trello board you want to export, click on "Show Menu" > "More" > "Print and Export" > "Export as JSON". Save the JSON file to your local machine.

Download and install the ClickHouse client on your local machine. This is necessary for interacting with your ClickHouse database directly. You can find installation instructions on the official ClickHouse documentation website.

Determine the structure of your Trello data and create a corresponding table in ClickHouse to store the data. Use the ClickHouse client to execute SQL queries. For example:
```sql
CREATE TABLE trello_data (
id String,
name String,
description String,
due_date DateTime,
status String
) ENGINE = MergeTree()
ORDER BY id;
```

Write a script in a language such as Python to parse the exported JSON file. The script should extract relevant fields such as card ID, name, description, due date, and status. Python’s built-in `json` module can be used for this task.

Continue with the same script to transform the parsed data into a format suitable for SQL insertion into ClickHouse. Prepare the data as a list of tuples or a CSV string, ensuring that date and time formats match ClickHouse’s requirements.

Use the ClickHouse client or a Python library like `clickhouse-driver` to connect to your ClickHouse instance and execute an `INSERT` SQL command. For example, using Python:
```python
from clickhouse_driver import Client

client = Client('localhost')
client.execute('INSERT INTO trello_data VALUES', data) # 'data' is your transformed dataset
```

After inserting the data, run a `SELECT` query in the ClickHouse client to verify that all records have been correctly transferred and stored in the database. Check for any discrepancies or errors in data transformation and insertion:
```sql
SELECT * FROM trello_data;
```

This guide should help you manually transfer data from Trello to ClickHouse without relying on third-party connectors or integrations.