To open a local Bitcoin database, you’ll generally be working with a Bitcoin full node or a wallet that stores data on your device. Here’s a simple breakdown:

Install Bitcoin Core: First, download and install the Bitcoin Core client from bitcoin.org.

Sync with the Blockchain: After installing, Bitcoin Core will start downloading the entire Bitcoin blockchain. This can take a while, depending on your internet speed.

Access the Database: Once synced, your wallet’s data is stored in the wallet.dat file. This file holds all your transaction history and wallet information.

Using RPC (Optional): If you’re familiar with coding, you can use Bitcoin Core's RPC commands to interact with the database and query data.

Find the Data Files: The blockchain data is typically stored in the Bitcoin data directory (like ~/.bitcoin/ on Linux or C:\Users<username>\AppData\Roaming\Bitcoin\ on Windows).

source : Bitcoin Core Documentation, Bitcoin Core RPC Documentation for more information visit coinfomania