---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github/duckdb/community-extensions repository, check README there
title: cloudfs
excerpt: |
  DuckDB Community Extensions
  Query SharePoint, OneDrive, Google Drive, Dropbox, SFTP, and any VPS (via cloudfs-agent) using spfs://, odfs://, gdfs://, dbxfs://, sftp://, and vfs:// — with the same capabilities as s3://. Supports Parquet, CSV, JSON, Delta Lake, Iceberg, glob patterns, and COPY TO across all providers.


extension:
  name: cloudfs
  description: >
    Query SharePoint, OneDrive, Google Drive, Dropbox, SFTP, and any VPS
    (via cloudfs-agent) using spfs://, odfs://, gdfs://, dbxfs://,
    sftp://, and vfs:// — with the same capabilities as s3://.
    Supports Parquet, CSV, JSON, Delta Lake, Iceberg, glob patterns,
    and COPY TO across all providers.
  version: 0.1.0
  language: C++
  build: cmake
  license: MIT
  maintainers:
    - trouchet
  requires_toolchains:
    - cmake
    - curl
    - openssl
    - libssh2

repo:
  github: trouchet/cloudfs
  ref: 4ca1432dfa01dffae0b167ba96b44720f0e39d83

docs:
  hello_world: |
    -- Auth on SharePoint (Interactive Device Code Flow)
    CREATE PERSISTENT SECRET sp (
        TYPE sharepoint, PROVIDER oauth,
        TENANT_ID 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx'
    );
    -- Read Parquet directly on SharePoint (as s3://)
    SELECT year, sum(revenue)
    FROM read_parquet('spfs://empresa.sharepoint.com/sites/Data/Docs/**/*.parquet',
                      hive_partitioning := true)
    GROUP BY year;

    -- VPS withcloudfs-agent (any Linux/Mac)
    CREATE SECRET servidor (TYPE vfs, PROVIDER token, TOKEN 'seu-token');
    SELECT * FROM ls('vfs://10.0.0.5:8765/data/', recursive := true);
    COPY (SELECT ...) TO 'vfs://10.0.0.5:8765/exports/resultado.parquet';

  extended_description: |
    cloudfs registers six URL schemes with DuckDB's virtual filesystem:

    | Scheme   | Provider       | Auth                         |
    |----------|----------------|------------------------------|
    | spfs://  | SharePoint     | OAuth2 Device Code / token   |
    | odfs://  | OneDrive       | OAuth2 Device Code / token   |
    | gdfs://  | Google Drive   | OAuth2 PKCE / Service Acct   |
    | dbxfs:// | Dropbox        | OAuth2 PKCE / token          |
    | sftp://  | Any VPS/server | SSH key / agent / password   |
    | vfs://   | cloudfs-agent  | Bearer token                 |

    All formats that work with s3:// work here too: Parquet, CSV, JSON,
    Delta Lake, Apache Iceberg, Hive partitioning, COPY TO, glob patterns.

    cloudfs-agent is an ~8 MB static Go binary that turns any Linux server
    into a vfs:// endpoint with HTTP range reads and bearer-token auth.
    Deploy with: ./cloudfs-agent --token $(openssl rand -hex 32) --root /data

extension_star_count: 2
extension_star_count_pretty: 2
extension_download_count: 463
extension_download_count_pretty: 463
image: '/images/community_extensions/social_preview/preview_community_extension_cloudfs.png'
layout: community_extension_doc
---

### Installing and Loading
```sql
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};
```

{% if page.docs.hello_world %}
### Example
```sql
{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}

### Added Functions

<div class="extension_functions_table"></div>

|    function_name    | function_type | description | comment | examples |
|---------------------|---------------|-------------|---------|----------|
| cloudfs_clear_cache | scalar        | NULL        | NULL    |          |
| cloudfs_providers   | scalar        | NULL        | NULL    |          |
| cloudfs_version     | scalar        | NULL        | NULL    |          |
| du                  | table         | NULL        | NULL    |          |
| ls                  | table         | NULL        | NULL    |          |
| stat                | table         | NULL        | NULL    |          |

### Overloaded Functions

<div class="extension_functions_table"></div>

This extension does not add any function overloads.

### Added Types

<div class="extension_types_table"></div>

This extension does not add any types.

### Added Settings

<div class="extension_settings_table"></div>

This extension does not add any settings.