The LangSmith UI does not currently support the deletion of an individual organization from a self-hosted instance of LangSmith. This, however, can be accomplished by directly removing all traces from all materialized views in ClickHouse (except the runs_history views) and the runs and feedbacks tables and then removing the Organization from the Postgres tenants table. This command using the Organization ID as an argument.

​
Prerequisites

Ensure you have the following tools/items ready.
  1. kubectl
  2. PostgreSQL client
  3. PostgreSQL database connection:
    • Host
    • Port
    • Username
      • If using the bundled version, this is postgres
    • Password
      • If using the bundled version, this is postgres
    • Database name
      • If using the bundled version, this is postgres
  4. Clickhouse database credentials
    • Host
    • Port
    • Username
      • If using the bundled version, this is default
    • Password
      • If using the bundled version, this is password
    • Database name
      • If using the bundled version, this is default
  5. Connectivity to the PostgreSQL database from the machine you will be running the migration script on.
    • If you are using the bundled version, you may need to port forward the postgresql service to your local machine.
    • Run kubectl port-forward svc/langsmith-postgres 5432:5432 to port forward the postgresql service to your local machine.
  6. Connectivity to the Clickhouse database from the machine you will be running the migration script on.
    • If you are using the bundled version, you may need to port forward the clickhouse service to your local machine.
      • Run kubectl port-forward svc/langsmith-clickhouse 8123:8123 to port forward the clickhouse service to your local machine.
    • If you are using Clickhouse Cloud you will want to specify the —ssl flag and use port 8443
  7. The script to delete an organization
    • You can download the script from here

​
Running the deletion script for a single organization

Run the following command to run the organization removal script: 
sh delete_organization.sh <postgres_url> <clickhouse_url> --organization_id <organization_id>
For example, if you are using the bundled version with port-forwarding, the command would look like: 
sh delete_organization.sh "postgres://postgres:postgres@localhost:5432/postgres" "clickhouse://default:password@localhost:8123/default" --organization_id 4ec70ec7-0808-416a-b836-7100aeec934b
If you visit the Langsmith UI, you should now see organization is no longer present.