index.html

---
layout: default
title: An in-process SQL OLAP database management system
subtitle: An In-Process Analytical Database
description: DuckDB is an in-process SQL OLAP database management system. Simple, feature-rich, fast & open source.
body_class: landing nowrap
banner: false
---

{% comment %}
To add a banner, set banner: true in the front matter and define the banner content in includes/landingpage_banner.html
{% endcomment %}

<section class="welcome">
	<div class="flexwrap wrap">
		<div class="duckdb">
			<h1 class="display-1">DuckDB is a fast <br/><div class="type" data-strings="analytical|in-process|open-source|portable">|</div> <br/>database system</h1>
			<p>Query and transform your data anywhere <br/>using DuckDB's feature-rich SQL dialect</p>
			<a class="button transparent arrow-down dark" href="#quickinstall">Installation</a>
			<a class="button yellow" href="/docs/">Documentation</a>
		</div>
		<div class="demo window">
			<div>
				<div class="topbar">
					<ul class="lang">
						<div class="select-highlight"></div>
						<li data-language="sql" class="active">SQL</li>
						<li data-language="python">Python</li>
						<li data-language="r">R</li>
						<li data-language="java">Java</li>
						<li data-language="nodejs">Node.js</li>
					</ul>
				</div>
				<div class="content haslines">
					<div class="lines"></div>
						<div class="code">
{% highlight sql %}
{% include landing-page/sql/aggregation.sql %}
{% endhighlight -%}
						</div>
				</div>
				<div class="bottombar flexwrap">
					<div class="select">
						<select id="example-select">
							<option value="sql-aggregation-query">Aggregation query</option>
							<option value="sql-join-query">Join query</option>
							<option value="sql-csv-reader">Read remote CSV files</option>
							<option value="sql-parquet-reading">Read remote Parquet files</option>
							<option value="sql-spatial-extension">Spatial extension</option>
						</select>
					</div>
					<a class="button arrow-right livedemo" href="https://shell.duckdb.org/#queries=v0,%20%20-Create-table-from-Parquet-file%0ACREATE-TABLE-train_services-AS%0A----FROM-'https%3A%2F%2Fblobs.duckdb.org%2Ftrain_services.parquet'~%0A%0A%20%20-Get-the-top%203-busiest-train-stations%0ASELECT%0A----station_name%2C%0A----count(*)-AS-num_services%0AFROM-train_services%0AGROUP-BY-ALL%0AORDER-BY-num_services-DESC%0ALIMIT-3~%0A">Live demo</a>
				</div>
			</div>
		</div>
	</div>
</section>


<section class="metrics">
	<div class="wrap">
		<div class="numbersbox">
			<div>
				<div class="number">#1</div>
				<div class="label">open-source system<br/>in ClickBench hot runs</div>
			</div>
			<div class="divider"></div>
			<div>
				<div class="number">#3</div>
				<div class="label">most admired DB<br/>on Stack Overflow</div>
			</div>
			<div class="divider"></div>
			<div>
				<div class="number">20+</div>
				<div class="label">Fortune-100<br/>companies use DuckDB</div>
			</div>
			<div class="divider"></div>
			<div>
				<div class="number">25M+</div>
				<div class="label">downloads/<br/>month</div>
			</div>
			<div class="divider"></div>
			<div>
				<div class="number">SF 100k</div>
				<div class="label">TPC-H on a single<br/>machine</div>
			</div>
		</div>
		<div class="numbersbox-reference">*see <a href="{% post_url 2025-10-09-benchmark-results-14-lts %}">our blog post</a> for more details</div>
	</div>
</section>


<section class="whyduckdb">
	<div class="wrap feature-list">
		<h1 class="display-2">DuckDB at a glance</h1>
		<div class="flexwrap">
			<div class="featurebox">
				<div class="icon simple"></div>
				<h3 class="title-1">Simple</h3>
				<p class="body-small text-secondary-color">DuckDB was designed to be simple to use. It has zero dependencies, so it can be installed in seconds and deployed in milliseconds.</p>
				<a href="/why_duckdb#simple" class="textbutton arrow-right">Read more</a>
			</div>
			<div class="featurebox">
				<div class="icon portable"></div>
				<h3 class="title-1">Portable</h3>
				<p class="body-small text-secondary-color">DuckDB runs on all popular operating systems and hardware architectures. It has idiomatic client APIs for major programming languages.</p>
				<a href="/why_duckdb#portable" class="textbutton arrow-right">Read more</a>
			</div>
			<div class="featurebox">
				<div class="icon featurerich"></div>
				<h3 class="title-1">Feature-rich</h3>
				<p class="body-small text-secondary-color">DuckDB supports multiple file formats (CSV, Parquet, and JSON), data lake formats. It can also connect to network and cloud storage.</p>
				<a href="/why_duckdb#feature-rich" class="textbutton arrow-right">Read more</a>
			</div>
			<div class="featurebox">
				<div class="icon speed"></div>
				<h3 class="title-1">Fast</h3>
				<p class="body-small text-secondary-color">DuckDB runs queries at blazing speed. It uses parallel execution and can process larger-than-memory workloads.</p>
				<a href="/why_duckdb#fast" class="textbutton arrow-right">Read more</a>
			</div>
			<div class="featurebox">
				<div class="icon extensible"></div>
				<h3 class="title-1">Extensible</h3>
				<p class="body-small text-secondary-color">DuckDB is extensible by third-party features. User contributions are available as community extensions.</p>
				<a href="/why_duckdb#extensible" class="textbutton arrow-right">Read more</a>
			</div>
			<div class="featurebox">
				<div class="icon free"></div>
				<h3 class="title-1">Free</h3>
				<p class="body-small text-secondary-color">DuckDB, its core extensions and the DuckLake format are <nobr>open-source</nobr> under the permissive MIT License.</p>
				<a href="/why_duckdb#free" class="textbutton arrow-right">Read more</a>
			</div>
		</div>
	</div>
</section>

{% include quick_installation.html %}

<section class="blog">
	<div class="wrap">
		<h1 class="display-2">Blog</h1>
		<div class="newstileswrap">
			{% for post in site.posts limit:2 %}
				{% assign random_number = forloop.index | modulo: 3 | plus: 1 %}
				{% assign tag_classes = post.tags | join: ' ' | downcase | slugify %}
				{% if post.external_post_url %}
					{% assign is_external = true %}
					{% assign post_link = post.external_post_url %}
					{% assign link_target = "_blank" %}
					{% assign link_rel = "noopener noreferrer" %}
					{% assign source_domain = post.external_post_url | extract_domain %}
				{% else %}
					{% assign is_external = false %}
					{% assign post_link = post.url %}
					{% assign link_target = "_self" %}
					{% assign link_rel = "" %}
					{% assign source_domain = "duckdb.org" %}
				{% endif %}
				<div class="postpreview {{ tag_classes }}{% if is_external %} external-post{% endif %}" data-title="{{ post.title | escape }}" data-source="{{ source_domain }}">
					<a href="{{ post_link }}" class="blocklink" title="{{ post.title }}" target="{{ link_target }}"{% if link_rel != "" %} rel="{{ link_rel }}"{% endif %}></a>
					<div class="postimg custom">
						{% if post.thumb %}
							<img src="{{ post.thumb }}" alt="{{ post.title }}" class="zoom-image"/>
						{% else %}
							<img src="/images/blog/thumbs/placeholder-{{ random_number }}.svg" alt="Placeholder" class="zoom-image"/>
						{% endif %}
					</div>
					<div class="postdetails">
						{% if post.tags %}
						<div class="tags">
							{% for tag in post.tags %}
								<span class="tag">{{ tag }}</span>
							{% endfor %}
						</div>
						{% endif %}
						<h3 class="headline-3">{{ post.title }}</h3>
						<div class="meta text-secondary-color body-small">
							{% if is_external %}
								<div class="external-source">{{ post.external_post_url | extract_domain }}</div>
							{% endif %}
							<div class="date">{{ post.date | date: "%Y-%m-%d" }}</div>
							<div class="author">{{ post.author | default: "Unknown Author" }}</div>
						</div>
					</div>
				</div>
			{% endfor %}
		</div>
		<a href="{{ site.url }}/news" class="button transparent arrow-right">
			All blog posts <span></span>
		</a>
	</div>
</section>


<div class="landing_bg_1"></div>
<div class="landing_bg_2"></div>


<section class="hidden">
	
	
<div class="dropdown hero-demo">
	
<!-- example list for SQL -->	
<div data-language="sql">
	<option value="sql-aggregation-query">Aggregation query</option>
	<option value="sql-join-query">Join query</option>
	<option value="sql-csv-reader">Read CSV files</option>
	<option value="sql-parquet-reading">Read Parquet files from S3</option>
	<option value="sql-spatial-extension">Spatial extension</option>
</div>

<!-- example list for Python -->	
<div data-language="python">
	<option value="python-sql-query">SQL query</option>
	<option value="python-pandas-integration">Pandas integration</option>
	<option value="python-udf">Custom UDFs</option>
</div>

<!-- specific example list for R -->	
<div data-language="r">
	<option value="r-sql-query">SQL query</option>
	<option value="r-duckplyr">duckplyr</option>
	<option value="r-dplyr-integration">dplyr integration</option>
</div>

<!-- specific example list for Java -->	
<div data-language="java">
	<option value="java-sql-query">SQL query</option>
	<option value="java-appender">Appender</option>
</div>

<!-- specific example list for Node.js -->	
<div data-language="nodejs">
	<option value="nodejs-sql-query">SQL query</option>
	<option value="nodejs-web-service-integration">Web service integration</option>
</div>

</div>
	
<div class="examples hero-demo">
	
<!-- ------------------- SQL ------------------- -->

<div data-language="sql" data-example="sql-aggregation-query" data-buttontxt="Live demo" data-buttonurl="https://shell.duckdb.org/#queries=v0,%20%20-Create-table-from-Parquet-file%0ACREATE-TABLE-train_services-AS%0A----FROM-'https%3A%2F%2Fblobs.duckdb.org%2Ftrain_services.parquet'~%0A%0A%20%20-Get-the-top%203-busiest-train-stations%0ASELECT%0A----station_name%2C%0A----count(*)-AS-num_services%0AFROM-train_services%0AGROUP-BY-ALL%0AORDER-BY-num_services-DESC%0ALIMIT-3~%0A">
{% highlight sql %}
{% include landing-page/sql/aggregation.sql %}
{% endhighlight %}
</div>

<div data-language="sql" data-example="sql-csv-reader" data-buttontxt="Live demo" data-buttonurl="https://shell.duckdb.org/#queries=v0,%20%20-Load-CSV-file-to-a-table.-DuckDB-auto%20detects%0A%20%20-the-CSV's-format%2C-column-name-and-types%0ACREATE-TABLE-stations-AS%0A----FROM-'https%3A%2F%2Fblobs.duckdb.org%2Fstations.csv'~%0A">
{% highlight sql %}
{% include landing-page/sql/csv-loader.sql %}
{% endhighlight %}
</div>

<div data-language="sql" data-example="sql-parquet-reading" data-buttontxt="Live demo" data-buttonurl="https://shell.duckdb.org/#queries=v0,%20%20-Directly-query-Parquet-file-over-HTTPS%0ASELECT%0A----station_name%2C%0A----count(*)-AS-num_services%0AFROM-'https%3A%2F%2Fblobs.duckdb.org%2Ftrain_services.parquet'%0AGROUP-BY-ALL%0AORDER-BY-num_services-DESC%0ALIMIT-10~%0A">
{% highlight sql %}
{% include landing-page/sql/s3-parquet.sql %}
{% endhighlight %}
</div>

<div data-language="sql" data-example="sql-join-query" data-buttontxt="Live demo" data-buttonurl="https://shell.duckdb.org/#queries=v0,CREATE-TABLE-stations-AS%0A----FROM-'https%3A%2F%2Fblobs.duckdb.org%2Fstations.parquet'~%0ACREATE-TABLE-distances-AS%0A----FROM-'https%3A%2F%2Fblobs.duckdb.org%2Fdistances.parquet'~%0A%0A%20%20-Find-the-top%203-longest-domestic-train-routes%0ASELECT-s1.name_short%2C-s2.name_short%2C-d.distance%0AFROM-distances-d%0AJOIN-stations-s1-ON-d.station1-%3D-s1.code%0AJOIN-stations-s2-ON-d.station2-%3D-s2.code%0AWHERE-s1.country-%3D-s2.country%0A--AND-s1.code-%3C-s2.code%0AORDER-BY-distance-DESC%0ALIMIT-3~%0A">
{% highlight sql %}
{% include landing-page/sql/join.sql %}
{% endhighlight %}
</div>

<div data-language="sql" data-example="sql-spatial-extension" data-buttontxt="Live demo" data-buttonurl="https://shell.duckdb.org/#queries=v0,%20%20-Spatial-extension-for-geospatial-support%0AINSTALL-spatial~%0ALOAD-spatial~%0A%0ACREATE-TABLE-stations-AS%0A----FROM-'https%3A%2F%2Fblobs.duckdb.org%2Fstations.parquet'~%0A%0A%20%20-What-are-the-top%203-closest-Intercity-stations%0A%20%20-using-aerial-distance%3F%0ASELECT%0A----s1.name_long-AS-station1%2C%0A----s2.name_long-AS-station2%2C%0A----ST_Distance(%0A--------ST_Point(s1.geo_lng%2C-s1.geo_lat)%2C%0A--------ST_Point(s2.geo_lng%2C-s2.geo_lat)%0A----)-*-111_139-AS-distance%0AFROM-stations-s1%2C-stations-s2%0AWHERE-s1.type-LIKE-'%25Intercity%25'%0A--AND-s2.type-LIKE-'%25Intercity%25'%0A--AND-s1.id-%3C-s2.id%0AORDER-BY-distance-ASC%0ALIMIT-3~%0A">
{% highlight sql %}
{% include landing-page/sql/spatial-extension.sql %}
{% endhighlight %}
</div>

<!-- ------------------- Python -------------------- -->

<div data-language="python" data-example="python-sql-query" data-buttontxt="Python documentation" data-buttonurl="/docs/api/python/overview">
{% highlight python %}
{% include landing-page/python/sql-query.py %}
{% endhighlight %}
</div>

<div data-language="python" data-example="python-pandas-integration" data-buttontxt="Blog post" data-buttonurl="/2021/05/14/sql-on-pandas">
{% highlight python %}
{% include landing-page/python/pandas-integration.py %}
{% endhighlight %}
</div>

<div data-language="python" data-example="python-udf" data-buttontxt="Blog post" data-buttonurl="/2023/07/07/python-udf">
{% highlight python %}
{% include landing-page/python/udf.py %}
{% endhighlight %}
</div>

<!-- ------------------- R -------------------- -->

<div data-language="r" data-example="r-sql-query" data-buttontxt="R documentation" data-buttonurl="/docs/api/r">
{% highlight r %}
{% include landing-page/r/sql-query.r %}
{% endhighlight %}
</div>

<div data-language="r" data-example="r-duckplyr" data-buttontxt="R documentation" data-buttonurl="/docs/api/r">
{% highlight r %}
{% include landing-page/r/duckplyr.r %}
{% endhighlight %}
</div>

<div data-language="r" data-example="r-dplyr-integration" data-buttontxt="R documentation" data-buttonurl="/docs/api/r">
{% highlight r %}
{% include landing-page/r/dplyr-integration.r %}
{% endhighlight %}
</div>

<!-- ------------------- Java -------------------- -->

<div data-language="java" data-example="java-sql-query" data-buttontxt="Java (JDBC) documentation" data-buttonurl="/docs/api/java">
{% highlight java %}
{% include landing-page/java/sql-query.java %}
{% endhighlight %}
</div>


<div data-language="java" data-example="java-appender" data-buttontxt="Java (JDBC) documentation" data-buttonurl="/docs/api/java">
{% highlight java %}
{% include landing-page/java/appender.java %}
{% endhighlight %}
</div>

<!-- ------------------- Node.js -------------------- -->

<div data-language="nodejs" data-example="nodejs-sql-query" data-buttontxt="Node.js documentation" data-buttonurl="/docs/api/node_neo/overview">
{% highlight javascript %}
{% include landing-page/nodejs/sql-query.mjs %}
{% endhighlight %}
</div>

<div data-language="nodejs" data-example="nodejs-web-service-integration" data-buttontxt="Node.js documentation" data-buttonurl="/docs/api/node_neo/overview">
{% highlight javascript %}
{% include landing-page/nodejs/web-service-integration.mjs %}
{% endhighlight %}
</div>

</div>
	
</section>