# Integrations **URL:** https://community.cratedb.com/c/integrations/22.md [Latest](https://community.cratedb.com/latest.md) · [Categories](https://community.cratedb.com/categories.md) · [Tags](https://community.cratedb.com/tags.md) --- ## [Overview of CrateDB integration tutorials](https://community.cratedb.com/t/overview-of-cratedb-integration-tutorials/1015)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 0\ **Last updated:** [February 18, 2022, 9:02am UTC](https://community.cratedb.com/t/overview-of-cratedb-integration-tutorials/1015 "2022-02-18T09:02:00Z")
We’ve created many integration-focused tutorials to help you use CrateDB with other awesome tools and libraries.:point\_down: All tutorials require the working installation of CrateDB. Tool Articles/Tutorials C A… --- ## [About the Integrations category](https://community.cratedb.com/t/about-the-integrations-category/62)
**Author:** [@yash](https://community.cratedb.com/u/yash)\ **Replies:** 0
Questions regarding various integrations with CrateDB that might include 3rd Party Tools, Visualization Tools & Client Libraries and everything else. --- ## [Introducing the CrateDB MCP Server](https://community.cratedb.com/t/introducing-the-cratedb-mcp-server/2043)
**Author:** [@amotl](https://community.cratedb.com/u/amotl)\ **Replies:** 1\ **Last updated:** [June 19, 2025, 5:04pm UTC](https://community.cratedb.com/t/introducing-the-cratedb-mcp-server/2043 "2025-06-19T17:04:51Z")
About MCP, the Model Context Protocol, is an open protocol that enables seamless integration between LLM applications and external data sources and tools. The CrateDB MCP Server provides natural-language Text-to-SQL a… --- ## [Disk space issues on prometheus integration](https://community.cratedb.com/t/disk-space-issues-on-prometheus-integration/1848)
**Author:** [@cyberplant](https://community.cratedb.com/u/cyberplant)\ **Replies:** 7\ **Last updated:** [March 5, 2025, 9:22am UTC](https://community.cratedb.com/t/disk-space-issues-on-prometheus-integration/1848 "2025-03-05T09:22:34Z")
Hello! I’m building a new monitoring cluster on my company (Zyte) and looking for a clustered storage for prometheus. Found CrateDB and loved it! Installed and everything was working smoothly from the beginning. BUT… t… --- ## [Crate python package how to handle geo data?!?](https://community.cratedb.com/t/crate-python-package-how-to-handle-geo-data/1955)
**Author:** [@SchabiDesigns](https://community.cratedb.com/u/SchabiDesigns)\ **Replies:** 2\ **Last updated:** [January 13, 2025, 8:24am UTC](https://community.cratedb.com/t/crate-python-package-how-to-handle-geo-data/1955 "2025-01-13T08:24:36Z")
Dear Community I have a geopandas dataframe and would like to store it in crateDB. I failed with so many approaches and in the end I just did a simple test: import sqlalchemy as sa import pandas as pd engine = sa.crea… --- ## [First results using CrateDB with Tableau](https://community.cratedb.com/t/first-results-using-cratedb-with-tableau/1936)
**Author:** [@Mars\_Warrior](https://community.cratedb.com/u/Mars_Warrior)\ **Replies:** 1\ **Last updated:** [December 25, 2024, 12:03pm UTC](https://community.cratedb.com/t/first-results-using-cratedb-with-tableau/1936 "2024-12-25T12:03:52Z")
I managed to use CrateDB with Tableau using the CrateDB Tableau connector and a fairly large database with about 500 million rows. I ran into some small problems which could be solved eventually. Installation using Doc… --- ## [Problem connecting with Metabase \>= 0.48.4](https://community.cratedb.com/t/problem-connecting-with-metabase-0-48-4/1919)
**Author:** [@massimo\_ferrari](https://community.cratedb.com/u/massimo_ferrari)\ **Replies:** 6\ **Last updated:** [December 5, 2024, 2:59pm UTC](https://community.cratedb.com/t/problem-connecting-with-metabase-0-48-4/1919 "2024-12-05T14:59:41Z")
Hello, I’ve installed a CrateDB cluster (v 5.9.2) on Hetzner Cloud, 5 nodes on ARM machines (ubuntu 24.04). Each node has 4cpu, 8GB ram, external extensible SSD. I am feeding it daily/hourly with various data arrivin… --- ## [Migration from crate\[sqlalchemy\] to sqlalchemy-cratedb](https://community.cratedb.com/t/migration-from-crate-sqlalchemy-to-sqlalchemy-cratedb/1786)
**Author:** [@amotl](https://community.cratedb.com/u/amotl)\ **Replies:** 1\ **Last updated:** [November 5, 2024, 3:14pm UTC](https://community.cratedb.com/t/migration-from-crate-sqlalchemy-to-sqlalchemy-cratedb/1786 "2024-11-05T15:14:26Z")
About In June 2024, code from the package crate\[sqlalchemy\] has been transferred to the package sqlalchemy-cratedb. For 80% of all use cases, this will be a drop-in replacement with no noticeable changes. For the remai… --- ## [I have done wrong installation](https://community.cratedb.com/t/i-have-done-wrong-installation/1887)
**Author:** [@Anupam\_Sharma](https://community.cratedb.com/u/Anupam_Sharma)\ **Replies:** 1\ **Last updated:** [October 16, 2024, 10:36am UTC](https://community.cratedb.com/t/i-have-done-wrong-installation/1887 "2024-10-16T10:36:49Z")
Dear community members can I uninstall and install CrateDB again on the same laptop for free due to wrong installation as my output was selected as Microsoft visual studio and I am not getting any out in my time series … --- ## [Imminent release : CrateDBAdmin.NET](https://community.cratedb.com/t/imminent-release-cratedbadmin-net/599)
**Author:** [@MikeMax](https://community.cratedb.com/u/MikeMax)\ **Replies:** 9\ **Last updated:** [October 3, 2024, 10:16am UTC](https://community.cratedb.com/t/imminent-release-cratedbadmin-net/599 "2024-10-03T10:16:08Z")
Hi, For professional purpose, i’m using CrateDB since several years. i was using a little self-made SQL Client (not really releasable :p). So i started, few months ago, to develop (once more) , from scratch, a new Admin… --- ## [CrateDB/postgres\_fdw/IN filter](https://community.cratedb.com/t/cratedb-postgres-fdw-in-filter/1860)
**Author:** [@jazzphoenix](https://community.cratedb.com/u/jazzphoenix)\ **Replies:** 2\ **Last updated:** [September 24, 2024, 8:45am UTC](https://community.cratedb.com/t/cratedb-postgres-fdw-in-filter/1860 "2024-09-24T08:45:47Z")
Hello everyone!! First of all, thank you very much for how amazing CrateDB is. I am trying to use FDW to visualize the CrateDB tables from PostgreSQL. Some queries work perfectly for me, but one query where I use IN th… --- ## [Python crate using multiple cursors parallel](https://community.cratedb.com/t/python-crate-using-multiple-cursors-parallel/1788)
**Author:** [@SchabiDesigns](https://community.cratedb.com/u/SchabiDesigns)\ **Replies:** 17\ **Last updated:** [September 12, 2024, 7:40am UTC](https://community.cratedb.com/t/python-crate-using-multiple-cursors-parallel/1788 "2024-09-12T07:40:33Z")
Hello guys The documentation says to initialize a connection and create cursors and then use them to execute queries and fetch data. Can multiple cursors been created and do jobs parallel? Or is there another approach t… --- ## [Ingest with python asyncpg](https://community.cratedb.com/t/ingest-with-python-asyncpg/1792)
**Author:** [@SchabiDesigns](https://community.cratedb.com/u/SchabiDesigns)\ **Replies:** 7\ **Last updated:** [June 28, 2024, 12:17pm UTC](https://community.cratedb.com/t/ingest-with-python-asyncpg/1792 "2024-06-28T12:17:39Z")
Hi guys I have some issues to ingest data with python and the asyncpg package. I have a dataframe with following datatypes: int32, datetime64\[ns, UTC\], object, float64, int32 …and want to ingest with: await connectio… --- ## [Prometheus failed to write data into CrateDB after encountering error 'A document with the same primary key exists already'](https://community.cratedb.com/t/prometheus-failed-to-write-data-into-cratedb-after-encountering-error-a-document-with-the-same-primary-key-exists-already/1724)
**Author:** [@Jun\_Zhou](https://community.cratedb.com/u/Jun_Zhou)\ **Replies:** 4\ **Last updated:** [February 27, 2024, 10:53am UTC](https://community.cratedb.com/t/prometheus-failed-to-write-data-into-cratedb-after-encountering-error-a-document-with-the-same-primary-key-exists-already/1724 "2024-02-27T10:53:35Z")
I have successfully integrate prometheus with CrateDB as link https://github.com/crate/cratedb-prometheus-adapter, while prometheus don’t write data into CrateDB after encountering error ‘ERROR: A document with the same … --- ## [CrateDB Prometheus Adapter croaks with err="context deadline exceeded"](https://community.cratedb.com/t/cratedb-prometheus-adapter-croaks-with-err-context-deadline-exceeded/376)
**Author:** [@RyanWN4](https://community.cratedb.com/u/RyanWN4)\ **Replies:** 16\ **Last updated:** [February 12, 2024, 6:18pm UTC](https://community.cratedb.com/t/cratedb-prometheus-adapter-croaks-with-err-context-deadline-exceeded/376 "2024-02-12T18:18:32Z")
Hey guys, So I’m currently running a 3 node CrateDB cluster for Prometheus long term storage and using the CrateDB adapter provided by crateio. I’ve ran into an issue where Prometheus is attempting to POST data to the r… --- ## [Java Strategy for CrateDB](https://community.cratedb.com/t/java-strategy-for-cratedb/1311)
**Author:** [@ulim](https://community.cratedb.com/u/ulim)\ **Replies:** 15\ **Last updated:** [January 11, 2024, 10:39pm UTC](https://community.cratedb.com/t/java-strategy-for-cratedb/1311 "2024-01-11T22:39:14Z")
Hi there, I’m new to CrateDB (although not to distributed datastores and clusters in general) and wonder what the recommended practice is for Java development. I see that there used to be a Spring Data adapter, but that… --- ## [CrateDB 5.5 not working out of the box with Npgsql 8: A PostgreSQL type with the name 'unknown' was not found in the current database info](https://community.cratedb.com/t/cratedb-5-5-not-working-out-of-the-box-with-npgsql-8-a-postgresql-type-with-the-name-unknown-was-not-found-in-the-current-database-info/1689)
**Author:** [@Jonas18](https://community.cratedb.com/u/Jonas18)\ **Replies:** 7\ **Last updated:** [January 10, 2024, 1:28pm UTC](https://community.cratedb.com/t/cratedb-5-5-not-working-out-of-the-box-with-npgsql-8-a-postgresql-type-with-the-name-unknown-was-not-found-in-the-current-database-info/1689 "2024-01-10T13:28:08Z")
Hello, It is the same issue as the one raised on the Npgsql Github. When trying to connect an error will be raised claiming a type with the name unknown was not found. The solution of disabling type loading works howev… --- ## [Error on run migration scripts](https://community.cratedb.com/t/error-on-run-migration-scripts/1354)
**Author:** [@Aristotelis\_Papanton](https://community.cratedb.com/u/Aristotelis_Papanton)\ **Replies:** 2\ **Last updated:** [November 24, 2023, 5:06pm UTC](https://community.cratedb.com/t/error-on-run-migration-scripts/1354 "2023-11-24T17:06:19Z")
Hello, We explore the development processes of Crate Db in order to use it in a project. We create a simple instance of crate in docker with crate:latest( 5.1.3) and a sample project on .net using .net core 7 Based o… --- ## [New Power BI Connector for CrateDB (unofficial)](https://community.cratedb.com/t/new-power-bi-connector-for-cratedb-unofficial/1648)
**Author:** [@Markus](https://community.cratedb.com/u/Markus)\ **Replies:** 0\ **Last updated:** [November 16, 2023, 4:46pm UTC](https://community.cratedb.com/t/new-power-bi-connector-for-cratedb-unofficial/1648 "2023-11-16T16:46:25Z")
Hey CrateDB community, Power BI connector for CrateDB v1.0 was finally released today! Features: manage & connect Power BI Desktop to cluster instance clear REST-API connectivity source: GitHub - markusbegerow/crate-… --- ## [Problems connecting with DBeaver](https://community.cratedb.com/t/problems-connecting-with-dbeaver/1587)
**Author:** [@cocoa](https://community.cratedb.com/u/cocoa)\ **Replies:** 1\ **Last updated:** [September 6, 2023, 7:51am UTC](https://community.cratedb.com/t/problems-connecting-with-dbeaver/1587 "2023-09-06T07:51:46Z")
Hi, it looks like the new DBeaver update doesn’t work with CrateDB. It’s probably the new ODBC driver with which CrateDB doesn’t seem to be compatible (or vice versa). --- ## [Using Crate JDBC in Dockerfile for Keycloak](https://community.cratedb.com/t/using-crate-jdbc-in-dockerfile-for-keycloak/1524)
**Author:** [@dennisn00](https://community.cratedb.com/u/dennisn00)\ **Replies:** 2\ **Last updated:** [June 28, 2023, 8:18am UTC](https://community.cratedb.com/t/using-crate-jdbc-in-dockerfile-for-keycloak/1524 "2023-06-28T08:18:07Z")
Hello everyone, I want to use CrateDB for my Keycloak server that is running as a Docker Container. Using the Postgres Driver that Keycloak offers, I get some problems with SQL statements that are not supported by Crate… --- ## [Backing up CrateDB in Kubernetes using Velero?](https://community.cratedb.com/t/backing-up-cratedb-in-kubernetes-using-velero/1377)
**Author:** [@jogu](https://community.cratedb.com/u/jogu)\ **Replies:** 4\ **Last updated:** [February 14, 2023, 2:12pm UTC](https://community.cratedb.com/t/backing-up-cratedb-in-kubernetes-using-velero/1377 "2023-02-14T14:12:24Z")
Hello! I have been trying to find information about how to back up CrateDB when it runs in a Kubernetes cluster using the tool Velero for backups. I am concerned about how to ensure that you have a consistent backup of… --- ## [Write-Behind Caching for CrateDB](https://community.cratedb.com/t/write-behind-caching-for-cratedb/1330)
**Author:** [@robd003](https://community.cratedb.com/u/robd003)\ **Replies:** 4\ **Last updated:** [January 19, 2023, 8:36pm UTC](https://community.cratedb.com/t/write-behind-caching-for-cratedb/1330 "2023-01-19T20:36:02Z")
Just wondering if anyone had a good solution for dealing with highly volatile data before storing the final results into CrateDB. Up until now I’ve just been storing every record in CrateDB and then manually deleting ol… --- ## [Stitch Data cannot connect - detecting CrateDB version instead of Postgres Version](https://community.cratedb.com/t/stitch-data-cannot-connect-detecting-cratedb-version-instead-of-postgres-version/1273)
**Author:** [@rijnhard](https://community.cratedb.com/u/rijnhard)\ **Replies:** 3\ **Last updated:** [November 4, 2022, 11:58am UTC](https://community.cratedb.com/t/stitch-data-cannot-connect-detecting-cratedb-version-instead-of-postgres-version/1273 "2022-11-04T11:58:43Z")
If I look at the docs Session settings — CrateDB: Reference it looks like crate does export the Postgres server version as server\_version. However it looks like stitch data is checking another way, which begs the ques… --- ## [Connecting CrateDB through Postgrest or Hasura Graphql](https://community.cratedb.com/t/connecting-cratedb-through-postgrest-or-hasura-graphql/570)
**Author:** [@Raghu\_Ram](https://community.cratedb.com/u/Raghu_Ram)\ **Replies:** 5\ **Last updated:** [September 10, 2022, 4:53pm UTC](https://community.cratedb.com/t/connecting-cratedb-through-postgrest-or-hasura-graphql/570 "2022-09-10T16:53:39Z")
Hi, Is there a possibility of integrating CrateDB with either PostgRest or Hasura Graphql. Any hints or documents can be helpful. I am new to cratedb … I just understood architecture of Cratedb. Some insights on conn… --- ## [Python client array of array binding](https://community.cratedb.com/t/python-client-array-of-array-binding/1196)
**Author:** [@iames](https://community.cratedb.com/u/iames)\ **Replies:** 3\ **Last updated:** [August 26, 2022, 6:15am UTC](https://community.cratedb.com/t/python-client-array-of-array-binding/1196 "2022-08-26T06:15:56Z")
I am trying to use the following query using the Python client (0.27.1) on Crate 4.8.2 and it is failing. The table looks like: |endpoint\_name |client\_id|role |enabled|modification\_date |creation\_dat… --- ## [Viewing data from IoT meters](https://community.cratedb.com/t/viewing-data-from-iot-meters/1175)
**Author:** [@djbestenergy](https://community.cratedb.com/u/djbestenergy)\ **Replies:** 2\ **Last updated:** [July 22, 2022, 12:03pm UTC](https://community.cratedb.com/t/viewing-data-from-iot-meters/1175 "2022-07-22T12:03:56Z")
Hello, Sorry if this seems a broad question! . Its in regards to the tools people use to view the data from CrateDB. I’ve got a specific use case that at the moment uses a custom browser front end, that works OK but no… --- ## [Pg\_replication\_slots error](https://community.cratedb.com/t/pg-replication-slots-error/1151)
**Author:** [@amr](https://community.cratedb.com/u/amr)\ **Replies:** 2\ **Last updated:** [June 15, 2022, 12:22pm UTC](https://community.cratedb.com/t/pg-replication-slots-error/1151 "2022-06-15T12:22:57Z")
error creating postgres connection e=db error: ERROR: Relation 'pg\_replication\_slots' unknown I have this error when I am trying to interact with crate/postgresql is this pg\_replication\_slots suported ? how can I confi… --- ## [DBSeeder Version 3.0.6](https://community.cratedb.com/t/dbseeder-version-3-0-6/1030)
**Author:** [@wwe](https://community.cratedb.com/u/wwe)\ **Replies:** 0\ **Last updated:** [March 1, 2022, 8:50am UTC](https://community.cratedb.com/t/dbseeder-version-3-0-6/1030 "2022-03-01T08:50:24Z")
We are pleased to release version 3.0.6 of DBSeeder. DBSeeder also supports the latest version of CrateDB available on Docker Hub (DBMS 4.7.0). --- ## [Npgsql with EF5: Received unexpected backend message ParseComplete](https://community.cratedb.com/t/npgsql-with-ef5-received-unexpected-backend-message-parsecomplete/966)
**Author:** [@Lukas](https://community.cratedb.com/u/Lukas)\ **Replies:** 9\ **Last updated:** [January 18, 2022, 9:08am UTC](https://community.cratedb.com/t/npgsql-with-ef5-received-unexpected-backend-message-parsecomplete/966 "2022-01-18T09:08:13Z")
Hi all I’m using CrateDB via EntityFramework 5 (5.0.13) and Npgsql 5.0.10. I want to add/update multiple entities at once. var newItems = new List\(); // code to fill list await context.AddRangeAsync(… [Next page](https://community.cratedb.com/c/integrations/22.md?page=1)