# How to verify, if database is Cassandra DB or Yugabyte DB?
**URL:** https://forum.yugabyte.com/t/how-to-verify-if-database-is-cassandra-db-or-yugabyte-db/1458
**Category:** General
**Created:** [February 18, 2022, 3:33pm UTC](https://forum.yugabyte.com/t/how-to-verify-if-database-is-cassandra-db-or-yugabyte-db/1458 "2022-02-18T15:33:19Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@sham\_yuga](https://forum.yugabyte.com/u/sham_yuga)
#### Post date: [February 18, 2022, 3:33pm UTC](https://forum.yugabyte.com/t/how-to-verify-if-database-is-cassandra-db-or-yugabyte-db/1458/1 "2022-02-18T15:33:19Z")
In our setup, below connection to database says Cassandra-3.9
```auto
[root@8d520 yugabyte]# ycqlsh 10.xx.xx.2 -u user -p passwd --ssl
Connected to local cluster at 10.xx.xx.x:9042.
[ycqlsh 5.0.1 | Cassandra 3.9-SNAPSHOT | CQL spec 3.4.2 | Native protocol v4]
Use HELP for help.
user@ycqlsh> DESCRIBE KEYSPACES;
system_schema system_auth system
```
I have been told that the database is yugabyteDB.
Yugaware GUI interface shows table as YCQL type
* * *
1. Why database type shown as Cassandra-3.9, in the above command? How to verify, if database is yugabyteDB or CassandraDB?
2. What is the difference between YSQL type table and YCQL type table?
---
### Author:  [@karthik](https://forum.yugabyte.com/u/karthik)
#### Post date: [February 18, 2022, 4:09pm UTC](https://forum.yugabyte.com/t/how-to-verify-if-database-is-cassandra-db-or-yugabyte-db/1458/2 "2022-02-18T16:09:49Z")
Hi @sham_yuga,
The database is YugabyteDB. It supports two APIs - YCQL (apache Cassandra compatible) and YSQL (PostgreSQL compatible). The above means that you created a cluster, and in it created 3 YCQL tables (apache Cassandra compatible).
This [FAQ on API compatibility](https://docs.yugabyte.com/latest/faq/compatibility/#what-does-api-compatibility-exactly-mean) may be useful for you.
---
### Author:  [@sham\_yuga](https://forum.yugabyte.com/u/sham_yuga)
#### Post date: [February 18, 2022, 4:51pm UTC](https://forum.yugabyte.com/t/how-to-verify-if-database-is-cassandra-db-or-yugabyte-db/1458/3 "2022-02-18T16:51:45Z")
@karthik
1. Can I say DocsDB? instead of yugabyteDB…
2. When you say, YSQL is PostgreSQL compatible, YSQL re-uses the _upper half_ of PostgreSQL with a horizontally scalable lower half called DocDB. Being horizontally scalable, how YSQL(or load balancer) finds the shard owner to execute the query?
---
### Author:  [@dorian\_yugabyte](https://forum.yugabyte.com/u/dorian_yugabyte)
#### Post date: [February 18, 2022, 5:44pm UTC](https://forum.yugabyte.com/t/how-to-verify-if-database-is-cassandra-db-or-yugabyte-db/1458/4 "2022-02-18T17:44:41Z")
> [@sham\_yuga](#):
>
> Being horizontally scalable, how YSQL(or load balancer) finds the shard owner to execute the query?
The client isn’t yet smart enough like in YCQL to directly route queries to the correct server: [Cluster aware driver for YSQL · Issue #7880 · yugabyte/yugabyte-db · GitHub](https://github.com/yugabyte/yugabyte-db/issues/7880)
---
### Author:  [@sham\_yuga](https://forum.yugabyte.com/u/sham_yuga)
#### Post date: [February 18, 2022, 6:30pm UTC](https://forum.yugabyte.com/t/how-to-verify-if-database-is-cassandra-db-or-yugabyte-db/1458/5 "2022-02-18T18:30:14Z")
@dorian_yugabyte
Does load balancer route queries to correct server(shard owner)?
If no, how queries are routed to correct shard owner?
---
### Author:  [@dorian\_yugabyte](https://forum.yugabyte.com/u/dorian_yugabyte)
#### Post date: [February 19, 2022, 2:00am UTC](https://forum.yugabyte.com/t/how-to-verify-if-database-is-cassandra-db-or-yugabyte-db/1458/6 "2022-02-19T02:00:29Z")
> [@sham\_yuga](#):
>
> Does load balancer route queries to correct server(shard owner)?
What do you mean by “load balancer”?
If an external one, then any yb-tserver will execute any query and do routing internally.