---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github.com/duckdb/community-extensions repository, check README there
title: magic
excerpt: |
  DuckDB Community Extensions
  libmagic/file utilities ported to DuckDB

extension:
  name: magic
  description: libmagic/file utilities ported to DuckDB
  version: 0.0.1
  language: C++
  build: cmake
  excluded_platforms: "linux_amd64_musl;windows_amd64_rtools;windows_amd64_mingw;windows_amd64"
  license: MIT
  maintainers:
    - carlopi

repo:
  github: carlopi/duckdb-magic
  andium: 6a214b48b6dc760e398c73131e00ee62f2c5f1bc
  ref: 00bf2b30a6e3ea1cac2cd86d8be8636bba93cf89

docs:
  hello_world: |
    --- Discover autodetected types for files in a folder
    SELECT magic_mime(file), magic_type(file), file
        FROM glob('path/to/folder/**');
    
    --- Inspect auto-detection capabilities of the `magic` extension
    FROM magic_capabilities();
    
    --- A remote GeoPackage — spatial, sniffed by content (runnable as-is):
    FROM read_any('https://www.geopackage.org/data/gdal_sample_v1.2_no_extensions.gpkg');
    
    --- A table inside a Postgres database (bring your own connection string):
    FROM read_any('postgres://user:pass@host:5432/mydb@public.orders');
    
    --- An Iceberg table on AWS S3 Tables (bring your own ARN + CREATE SECRET):
    FROM read_any('arn:aws:s3tables:us-east-1:123456789012:bucket/lake@analytics.events');
  extended_description: |
    Port of libmagic (that powers file UNIX utility), allow to classify files based on the content of the header, accoring to the libmagic library.
    Packaged with version 5.45 of the magic library. The magic.mgc database is at the moment statically compiled in the library, so it's the same across platforms but immutable.
    Implements read-from-any file capabilties, via magic auto-detection or name pattern.
    Implements also sub-resource dispatcher via `@schema.tbl`, allow also catalogs to be queried as a table.

extension_star_count: 8
extension_star_count_pretty: 8
extension_download_count: 716
extension_download_count_pretty: 716
image: '/images/community_extensions/social_preview/preview_community_extension_magic.png'
layout: community_extension_doc
---
### Compatibility Matrix

This table covers all DuckDB releases that have not reached [end-of-life](https://duckdb.org/release_calendar), including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

<div class="extension_compatibility_table"></div>

| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
| :--- | :---: | :---: | :---: | :---: | :---: |
| Linux AMD64 | ✅ | ❌ | ❌ | ✅ | ❌ |
| Linux ARM64 | ✅ | ❌ | ❌ | ✅ | ❌ |
| macOS AMD64 | ✅ | ❌ | ❌ | ✅ | ❌ |
| macOS ARM64 | ✅ | ❌ | ❌ | ✅ | ❌ |
| Windows AMD64 | ❌ | ❌ | ❌ | ❌ | ❌ |
| Windows ARM64 | ❌ | ❌ | ❌ | ❌ | ❌ |
| WebAssembly | ✅ | ❌ | ❌ | ✅ | ❌ |

### 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                                                             |
|---------------------------|---------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------|----------------------------------------------------------------------------------------------------------------------------------|
| magic_archive_members     | scalar        | NULL                                                                                                                                                             | NULL    |                                                                                                                                  |
| magic_capabilities        | table_macro   | NULL                                                                                                                                                             | NULL    |                                                                                                                                  |
| magic_mime                | scalar        | Returns the MIME type for the given file path using the libmagic database (e.g. 'application/json', 'text/plain').                                               | NULL    | [SELECT magic_mime('myfile.json');, SELECT file, magic_mime(file) AS mime FROM glob('data/**/*');]                               |
| magic_required_extensions | scalar        | Returns the list of DuckDB extensions that must be loaded before reading the given file with read_any(). Returns an empty list for built-in formats (CSV, blob). | NULL    | [SELECT magic_required_extensions('myfile.json');, SELECT file, magic_required_extensions(file) AS exts FROM glob('data/**/*');] |
| magic_type                | scalar        | Returns the file type description for the given file path using the libmagic database (e.g. 'Apache Parquet', 'JSON data').                                      | NULL    | [SELECT magic_type('myfile.parquet');, SELECT file, magic_type(file) AS type FROM glob('data/**/*');]                            |
| read_any                  | table_macro   | NULL                                                                                                                                                             | NULL    |                                                                                                                                  |
| read_any_impl             | table_macro   | NULL                                                                                                                                                             | NULL    |                                                                                                                                  |
| read_attacheable_database | table         | NULL                                                                                                                                                             | NULL    |                                                                                                                                  |
| read_har                  | table_macro   | NULL                                                                                                                                                             | NULL    |                                                                                                                                  |
| split_into_components     | scalar        | 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.