prisma:
    image: prismagraphql/prisma:1.13
    # container_name: "idea-prisma"
    restart: always
    depends_on:
      - postgres
    ports:
    - "4466:4466"
    environment:
      PRISMA_CONFIG: |
        port: 4466
        # uncomment the next line and provide the env var PRISMA_MANAGEMENT_API_SECRET=my-secret to activate cluster security
        managementApiSecret: mysecret123
        databases:
          default:
            connector: postgres
            host: postgres
            port: 5432
            user: prisma
            password: prisma
            migrations: true
            database: prisma

How can I delete my created database

prisma

? using Navicat premiun deleted ERROR: cannot drop the currently open database

You could stop the prisma server container and try it again.